software

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 quot;#N/Aquot; as a result!
The Formula I'm using is VLOOKUP(quot;totalquot;,'UK'!D:H,2,FALSE) but if
doesnt appear how can I get it to return a quot;0quot;.

Please can anybody help me?
Thanks
Mark--
certain_death
------------------------------------------------------------------------
certain_death's Profile: www.excelforum.com/member.php...oamp;userid=24561
View this thread: www.excelforum.com/showthread...hreadid=500098Hi Mark

Try
=IF(ISNA(VLOOKUP(quot;totalquot;,'UK'!D:H,2,FALSE)),0,VLOO KUP(quot;totalquot;,'UK'!D:H,2,FALSE))

--
Regards

Roger Govierquot;certain_deathquot;
gt; wrote in
message
news:certain_death.21gxgm_1136979601.5585@excelfor um-nospam.com...
gt;
gt; Hi,
gt; Can anyone help me please?
gt; I am doing a VLOOKUP against a Pivot Table which works fine, although
gt; if the value does not appear I get the Classic quot;#N/Aquot; as a result!
gt; The Formula I'm using is VLOOKUP(quot;totalquot;,'UK'!D:H,2,FALSE) but if
gt; doesnt appear how can I get it to return a quot;0quot;.
gt;
gt; Please can anybody help me?
gt; Thanks
gt; Mark
gt;
gt;
gt; --
gt; certain_death
gt; ------------------------------------------------------------------------
gt; certain_death's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24561
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500098
gt;

Roger,

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

Worked a treat.......!

Thanks very much....

Forever in your debt......
Regards
Mark
--
certain_death
------------------------------------------------------------------------
certain_death's Profile: www.excelforum.com/member.php...oamp;userid=24561
View this thread: www.excelforum.com/showthread...hreadid=500098