IF Function
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
|