Try this:

=IF(ISNA(VLOOKUP(B3,Revised,2,0)),IF(ISNA(VLOOKUP( B3,Projected,2,0)),"",VLOOKUP(B3,Projected,2,0)),V LOOKUP(B3,Revised,2,0))

--
Biff
Microsoft Excel MVP


"Alicia" wrote in message
...
I am trying to return a blank when my lookup value is not in either my
Revised or Projected range.

=IF(ISNA(VLOOKUP($B$3,Revised,2,FALSE)),VLOOKUP($B $3,Projected,2,FALSE),VLOOKUP($B$3,Revised,2,FALSE ))

Any suggestions?

Alicia