=VLOOKUP(trim(G9,Dept!$A$9:$B$157,2,FALSE)
sometimes the formating isn't exact and this helps me a great deal.
Good Luck.
--
Jules
"boousaf" wrote:
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