You could check (up to three times):

=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE)),"",
IF(VLOOKUP(A1,Sheet2!A:B,2,FALSE)="","",VLOOKUP(A1 ,Sheet2!A:B,2,FALSE)))

or since you want to see "", you could check up to twice:

=IF(ISERROR(1/LEN(VLOOKUP(A1,Sheet2!A:B,2,FALSE))),"",
VLOOKUP(A1,Sheet2!A:B,2,FALSE))

(change the range/range names to what you want.)



Jim wrote:

I am using the following:

=IF(ISERROR(VLOOKUP(D6,Pri_Bus_Unit,2,FALSE)),"",( VLOOKUP(D6,Pri_Bus_Unit,2,FALSE)))

It is returning a 0 (zero) instead of a blank cell. The cells are formatted
as general. Even if I am using "-" a dash it is returning zero.

Any thoughts?

--

Dave Peterson