vlookup
The second one is nicer!
Jim wrote:
The first one is the charm, thanks
"Dave Peterson" wrote:
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
--
Dave Peterson
|