=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

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

Hi,

You could use:

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

or if you are running 2007

=IF($E8="","",IFERROR(VLOOKUP($E8,Pension,9,),"Def ined"))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"HR Director" wrote:

=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