Entering a value should give me corresponding value from the legend I made.

[aditya.sunkara]

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.

[Ali Kırksekiz]

Did you check red sign (TRUE;FALSE) =VLOOKUP(lookup_value,table array,col_index_num,0)

If you put 1 instead of 0 then VLOOKUP might not return the correct value. If you use 1 then VLOOKUP gives approximate match.

[adhawan06]

Hi Aditya,

Welcome to the forum.

You can also use the Index Match function to get the corresponding value.

Lets say, you have assigned the numbers in Col "I" & Fruits Name in Col "J". Now, if you enter 1 in B3, so use the following function in C3

Please Login or Register  to view this content.

this will also work.

Cheers!!

Anil Dhawan