View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HR Director HR Director is offline
external usenet poster
 
Posts: 2
Default working with nested vlookup formulas

=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