Help With #n/a From Vlookup

certain_death · Jan 11, 2006

Hi,
Can anyone help me please?
I am doing a VLOOKUP against a Pivot Table which works fine, althoug
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 i
doesnt appear how can I get it to return a "0".

Please can anybody help me?
Thanks
Mark:

Roger Govier · Jan 11, 2006

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"
message
news:[email protected]...

certain_death · Jan 11, 2006

Roger,

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

Worked a treat.......!

Thanks very much....

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