Question about Microsoft Windows XP Professional
Can I enter a particular text in cell linked through a number? i.e. my cell B1 should contain "lemon" if I enter 1 in cell A1, "mango" if enter 2 in cell A1 and other such texts linked with particular numbers.
You can give the formula by the lookup function
at first make the lists in an another sheet e.g. in sheet2 write the following entries for reference :
then in sheet1 write the following formula in cell b1
then enter the num upto the limit of lists.
the cell b1 will take values from the reference cell of sheet2
your problem must will be solve.
Posted on Aug 08, 2008
Yes, its possible by designing a formula in excel.
Posted on Aug 03, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 17, 2014 | Computers & Internet
Sep 17, 2009 | Microsoft Excel for PC
Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC
Sep 29, 2008 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Computers & Internet
Apr 13, 2008 | Computers & Internet
Jan 31, 2008 | Computers & Internet
132 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: