Hi to everyone,

Anybody knows how 2 make a validation with a vlookup as formula?

I have 2 lists in 2 columns (A & B). In column A I have numbers and in B names, and what I want is something like if in C1 I type 1 it will appear the name that is in front of that number in the list.

Expl:
A.....B.............C
1...Joe.........Type 2 but will appear Carol
2...Carol

Thk u for any help