View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jane Jane is offline
external usenet poster
 
Posts: 202
Default is blank AND is error

This is my formula

'=IF(ISBLANK(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)),"",(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)))

I am getting #NA when there is not a match so need to have a combo of
isblank and iserror... is this possible?

thanks in advance! jane