Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem...
Hi Guys, I've been scratching my head all day with this vlookup problem (getting #n/a errors). Please excuse the noobness - first post. Can you see anything wrong with this on the surface? =VLOOKUP(G9,Dept!A9:B157,2,FALSE) I am trying to tell excel to look at the dept value (G9), and populate the locations based on the location listed on the department tab (dept), and i keep getting na errors... any ideas or direction would be greatly appreciated! -- boousaf ------------------------------------------------------------------------ boousaf's Profile: http://www.excelforum.com/member.php...o&userid=37313 View this thread: http://www.excelforum.com/showthread...hreadid=570188 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem | Excel Discussion (Misc queries) | |||
Vlookup problem with Date Time | Excel Worksheet Functions | |||
vlookup Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |