How to make VLOOKUP return 0 (ZERO) if the search criteria is not found

Originally Posted by carstowal

I want to make VLOOKUP return 0 (ZERO) if the search criteria is not found.
(or find another function to use)

I have a spreadsheet of shipped items.
Those that were air freighted return a cost in the air freight column based on a VLOOKUP from the air freight cost spreadsheet.
Those that were not air shipped return #N/A because they were not found.
I cannot total my air freight cost column because of the #N/A results

=If(Vlookup("seek",table,1,false)<>"seek",0,Vlookup("seek",table,2,false))

or

=If(iserror(Vlookup("seek",table,2,false)),0,Vlookup("seek",table,2,false))

should do that.

note, the 0 can be replaced with another function.
---