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