You should start a new thread, as this has nothing to do with the OP's
question.
Anyway, sounds like you need VLOOKUP.

NickHK

"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