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