Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks