This formula is works great in there is a number in the E collumn.

Does E column mean E8 in the formula?

Maybe this:

=IF(ISNA(VLOOKUP($E8,Pension,9,0)),"",VLOOKUP($E8, Pension,9,0))


--
Biff
Microsoft Excel MVP


"HR Director" wrote in message
...
=IF(ISNA(VLOOKUP($E8,Pension,9,FALSE)),"Defined",V LOOKUP($E8,Pension,9,FALSE))

This formula is works great in there is a number in the E collumn. but if
there is no number in the E column it show "defined" I what it to show
nothing. any ideas