Hi,

I have a situation, where I have to create a reference table. In the main work area, if I enter the value from the table, in the adjacent cell, I need the corresponding value..

lets say I have assigned 1 = apple, 2= orange 3= mango,

In the main work sheet Once in lets say B3 cell I enter 1, In the C3 cell, I want the response to read apple.

I tried if function and Vlookup but to no avail.