Vlookup uses the values in the left hand column of an array and returns the
correspond value in the right hand column. Try Lookup

=LOOKUP(C16,O2:O120,N2:N120)

"TJAC" wrote:

I have a VLOOkUp function that I'm trying to use. I would like to enter a
name and in the other column the number be populated for their region.
However, that way does not work. When I type in the name, a number doesn't
come into the other cell. But if I try it the other way, type in the number
the name does appear. I can't figure out what is wrong. My formula appears
to be correct since I can change it and it will add the name.

Any ideas on what I can try?

This is my function...
=VLOOKUP(C16,$N$2:$O$120,1)
Column N contains the numbers and column O contains the names. Obviously
c16 is where I am attempting to type the name.

Thanks!