Two things, If you're dragging this down you need to make the range
absolute,

=VLOOKUP(G9,Dept!$A$9:$B$157,2,FALSE)

not,

=VLOOKUP(G9,Dept!A9:B157,2,FALSE)

Is it all on one sheet? If you're using two sheets try

=VLOOKUP(Dept!G9,Dept!A9:B157,2,FALSE)

Regards,
Alan.




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" wrote in
message ...

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