Try this:

=IF(ISNA(VLOOKUP(........)),"",VLOOKUP(........))

That will return a blank cell. If you'd rather have a 0 returned just
replace "" with 0.

Biff

"djbrothers" wrote in message
...
In reference to this, does anyone know how to suppress the "#N/A" value in
the cell. I am trying to do the vlookup and then use the cell in a sum
formula. But with N/A in there it screws up the calculation with other
cells.

Jeff


"Jules" wrote:

=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