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 16, 2011 | Operating Systems
Nov 15, 2010 | Microsoft Windows XP Professional
Aug 15, 2010 | Operating Systems
Apr 01, 2010 | Microsoft Windows XP Professional
Sep 23, 2009 | Operating Systems
Jun 26, 2009 | Microsoft MS Windows XP Professional SP2
Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC
Dec 15, 2008 | Microsoft Windows XP Home Edition
Oct 08, 2008 | Microsoft Windows XP Home Edition
127 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: