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

R

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]...
 
T

Trevor Shuttleworth

Rachel

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

or

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

Regards

Trevor
 
Top