I need a VLOOKUP to display 0 or blank instead of N/A

[RagDyeR]

=IF(ISNA(MATCH(LookupValue,LookupColumn,0)),"",VLOOKUP(YourFormula)
--

HTH,

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

news:[email protected]...

 

[Trevor Shuttleworth]

Rachel

=IF(ISNA(your lookup),0,your lookup)

or

=IF(ISNA(your lookup),"",your lookup)

Regards

Trevor

 

[tjtjjtjt]

Rachel,

Try:

=(IF(ISNA(YourVlookup)),0,YourVlookup)

tj