Eliminate #n/a result in a vlookup?

[Joy Manning]

Hi all,

Just wondering if there is a workaround for a vlookup
function to return a null (0) value if its result is
invalid "#N/A". Is there an ISERR function? Any light
you can shed would be fantastic

 

[RagDyer]

Same question as the next post, so ... same answer.

However, you can replace the [ "" ] just before the VLOOKUP portion with a
zero (0) if you wish.

=IF(ISNA(MATCH(D2,A2:A100,0)),"",VLOOKUP(D2,A2:C100,3,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi all,

Just wondering if there is a workaround for a vlookup
function to return a null (0) value if its result is
invalid "#N/A". Is there an ISERR function? Any light
you can shed would be fantastic