Hi there,
I get all blanks now.

TO add (if this helps), I am trying to retrieve text although not sure if it
is formatted as text ...

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"jane" wrote in message
...
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