Help With #n/a From Vlookup

[certain_death]

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

[Roger Govier]

Hi Mark

Try
=IF(ISNA(VLOOKUP("total",'UK'!D:H,2,FALSE)),0,VLOOKUP("total",'UK'!D:H,2,FALSE))

--
Regards

Roger Govier


"certain_death"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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=500098
>

[certain_death]

Roger,

You are indeed a genius my friend.....

Worked a treat.......!

Thanks very much....

Forever in your debt......
Regards
Mark