Excel vlookup assistance

Dear Team,

I would like to have assistance from you related with an example related with vlookup. As shown in example.

On sheet 2 , I have values for A , B , C , D in numbers each and corresponding to alphabets in words such as Apple , Ball etc .

Now on sheet 1 , I know how to make vlookup with A and its corresponding number, if change the letter , the number too changes . This is perfect.
Now how can I add one more cell to it, so that when I change the letter , the number changes in one cell and another cell corresponding word comes too .

Appreciate your kind help and support.


Regards,

aaron
Test.xlsx
infiniti7181Asked:
Who is Participating?
 
FarWestConnect With a Mentor Commented:
never mind, I see
is it possible to make your order "A,1,Apple" instead of "Apple,A,1" in sheet 2
since the first column should be the index value in the range
otherwise you should have other formula columns for the above order "A,1,Apple" or "A,Apple,1" and use it as the vlookup range
0
 
FarWestCommented:
your question is not clear for me,
could modify  the sample with new request sample and make comments on cells to what values you want to see

Regards
0
 
infiniti7181Author Commented:
Hi ,
Sorry I attached an unsaved file . You can see in attached in brown cell highlighted and comment mentioned in red. I have added some values in sheet 2 .

Objective is ,
now this excel sheet works, when I select the cell corresponding value appears as per the table. How can I add one more cell to be visible , as shown in the excel sheet.

Regards, Aaron
Test.xlsx
0
 
infiniti7181Author Commented:
wow this works  as mentioned .

Thanks for your help and support

Regards,

Aaron
0
 
FarWestCommented:
Glad that it works for you
you  are welcome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.