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