And don't forget to make the second lookup table absolute also.

=IF(ISNA(VLOOKUP(C2,$A$2:$B$20,2,FALSE)),0,VLOOKUP (C2,$A$2:$B$20,2,FALSE))


Gord Dibben MS Excel MVP


On Fri, 30 Nov 2007 22:30:00 -0800, OssieMac
wrote:

Hi again,

My apologies. So used to returning null if not found I did it in the
formula. Should be following to return zero if not found:

=IF(ISNA(VLOOKUP(C2,$A$2:$B$20,2,FALSE)),0,VLOOKU P(C2,A2:B20,2,FALSE))