Hi Try
=IF(ISNA(VLOOKUP(Cell,Range,column,FALSE)),"0",VLO OKUP(Cell,Range,Column,False))

HTH
Michael

"Cmatise" wrote:

When VLOOKUP returns a #N/A How can you get it to replace #N/A with a 0