Help With #n/a From Vlookup
 

Hi,
Can anyone help me please?
I am doing a VLOOKUP against a Pivot Table which works fine, although
if the value does not appear I get the Classic "#N/A" as a result!
The Formula I'm using is VLOOKUP("total",'UK'!D:H,2,FALSE) but if
doesnt appear how can I get it to return a "0".

Please can anybody help me?
Thanks
Mark:)


--
certain_death
------------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=500095

Help With #n/a From Vlookup
 

You have to make it check for errors, then return 0 if an error.

=IF(ISERROR(VLOOKUP("total",'UK'!D:H,2,FALSE)),0,( VLOOKUP("total",'UK'!D:H,2,FALSE))
or
=IF(ISNA(VLOOKUP("total",'UK'!D:H,2,FALSE)),0,(VLO OKUP("total",'UK'!D:H,2,FALSE))
you can also make it return A blank by changing the 0 to ""

HTH
JG

"certain_death" wrote:


Hi,
Can anyone help me please?
I am doing a VLOOKUP against a Pivot Table which works fine, although
if the value does not appear I get the Classic "#N/A" as a result!
The Formula I'm using is VLOOKUP("total",'UK'!D:H,2,FALSE) but if
doesnt appear how can I get it to return a "0".

Please can anybody help me?
Thanks
Mark:)


--
certain_death
------------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=500095