Search a Table and paste the content from a specific cell

Dear members of the forum,

I try to explain my problem with the example sheet:

If I enter a number (from 1-10) in A4 a formula should search in "Sheet 2" for this number and enter the text next to this number in B4 (in the case of the example sheet "Person 3").

I though that maybe VLOOKUP or something like this could solve this problem, but I wasn't able to make it work.

Thank you in advance for your help and best regards,

David

Hi Ali,

thank you very much - this works just perfectly fine

Have a nice day and best regards,

David