Posted to microsoft.public.excel.worksheet.functions
|
|
Vlookup problem...
I did try that too but not no good. Are you sure it works and i'm just
putting it in incorrectly?
JB
"T. Valko" wrote:
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
|