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
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
Jan 10, 2009 | Computers & Internet
Sep 29, 2008 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Computers & Internet
Apr 13, 2008 | Computers & Internet
Jan 31, 2008 | Computers & Internet
Usually answered in minutes!
Step 2: Please assign your manual to a product: