working with nested vlookup formulas

[HR Director]

=IF(ISNA(VLOOKUP($E8,Pension,9,FALSE)),"Defined",VLOOKUP($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

 

[T. Valko]

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))

 

[Shane Devenshire]

Hi,

You could use:

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

or if you are running 2007

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