if your tables do not have duplicates and the value to lookup is in col C
and the values in col E.
=IF(ISNA(INDEX(E:E,MATCH(B3,C:C,0))),"",INDEX(E:E, MATCH(B3,C:C,0)))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
try
=IF(ISNA(VLOOKUP(B3,IF(ISNA(VLOOKUP(B3,revised,2,0 )),projected,revised),2,0)),"",VLOOKUP(B3,IF(ISNA( VLOOKUP(B3,revised,2,0)),projected,revised),2,0))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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