IF Function
You need to create a 2 column table that lists the code number and the
corresponding item name:
................F.............G
1.........Code........Item
2..........123..........Pen
3..........124..........Paper
4..........125..........Book
5..........126..........Chair
Then, use this formula in B1:
=IF(A1="","",VLOOKUP(A1,F$2:G$5,2,0))
Copy down as needed.
Biff
"PSL" wrote in message
...
Hi,
Could u please help me on the following issue:
If I given item code in A1 as 123 then B1 should display as "PEN":
I need to execute the Item Name in a cell B1 when I enter the Item Code in
A1.
Examples:
If I given item code in A1 as 123 then B1 should display as "PEN"
If I given item code in A2 as 124 then B2 should display as "PAPER"
Like this I have 18 Item Code were there.
Please help on this.
Thank You,
PSL
|