Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |