VLookup and #N/A
 

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

VLookup and #N/A
 

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

VLookup and #N/A
 

=IF(NOT(ISNA(VLOOKUP($B$3,Revised,2,FALSE))),VLOOK UP($B$3,Projected,2,FALSE),
IF(ISNA(VLOOKUP($B$3,Revised,2,FALSE)),"",VLOOKUP( $B$3,Revised,2,FALSE)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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

VLookup and #N/A
 

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

VLookup and #N/A
 

You weren't a million miles away, try this

=IF(ISNA(VLOOKUP(B3,Revised,2,FALSE)),IF(ISNA(VLOO KUP(B3,Projected,2,FALSE)),"",VLOOKUP(B3,Projected ,2,FALSE)),VLOOKUP(B3,Revised,2,FALSE))

Mike

"Alicia" wrote:

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

VLookup and #N/A
 

Thanks that works.

"Mike H" wrote:

You weren't a million miles away, try this

=IF(ISNA(VLOOKUP(B3,Revised,2,FALSE)),IF(ISNA(VLOO KUP(B3,Projected,2,FALSE)),"",VLOOKUP(B3,Projected ,2,FALSE)),VLOOKUP(B3,Revised,2,FALSE))

Mike

"Alicia" wrote:

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

VLookup and #N/A
 

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