Vlookup with either/or
 

Hi,
I'm hoping someone can help me out with what should be an easy task,
but I can't quite get it.
I'm trying to do a Vlookup for 2 columns (either/or) using this
formula:

=VLOOKUP(OR(A18,B18),data1,4,FALSE)

where 'data1' is my array on a separate sheet. It works fine for a
single vlookup, but no luck using the 'or' function.

Does anyone know how to do this?
Thanks in advance for any replies.

Terry

Vlookup with either/or
 

This not an allowed syntax.
You need 2 VLOOKUPs.
You 'll also have to think about which one has "the right of way".
You can check for no match with the ISNA() function.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| Hi,
| I'm hoping someone can help me out with what should be an easy task,
| but I can't quite get it.
| I'm trying to do a Vlookup for 2 columns (either/or) using this
| formula:
|
| =VLOOKUP(OR(A18,B18),data1,4,FALSE)
|
| where 'data1' is my array on a separate sheet. It works fine for a
| single vlookup, but no luck using the 'or' function.
|
| Does anyone know how to do this?
| Thanks in advance for any replies.
|
| Terry

Vlookup with either/or
 

On Sep 17, 11:02*am, "Niek Otten" wrote:
This not an allowed syntax.
You need 2 VLOOKUPs.
You 'll also have to think about which one has "the right of way".
You can check for no match with the ISNA() function.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ...

| Hi,
| I'm hoping someone can help me out with what should be an easy task,
| but I can't quite get it.
| I'm trying to do a Vlookup for 2 columns (either/or) using this
| formula:
|
| =VLOOKUP(OR(A18,B18),data1,4,FALSE)
|
| where 'data1' is my array on a separate sheet. *It works fine for a
| single vlookup, but no luck using the 'or' function.
|
| Does anyone know how to do this?
| Thanks in advance for any replies.
|
| Terry

Thanks for the info. Neik ... I will do 2 loopkups, just thought I
could combine them somehow.
Appreciate your input~!

Vlookup with either/or
 

=IF(COUNTIF(data1,A18),VLOOKUP(A18,data1,4,),VLOOK UP(B18,data1,4,))


" wrote:

Hi,
I'm hoping someone can help me out with what should be an easy task,
but I can't quite get it.
I'm trying to do a Vlookup for 2 columns (either/or) using this
formula:

=VLOOKUP(OR(A18,B18),data1,4,FALSE)

where 'data1' is my array on a separate sheet. It works fine for a
single vlookup, but no luck using the 'or' function.

Does anyone know how to do this?
Thanks in advance for any replies.

Terry

Vlookup with either/or
 

On Sep 17, 11:16*am, Teethless mama
wrote:
=IF(COUNTIF(data1,A18),VLOOKUP(A18,data1,4,),VLOOK UP(B18,data1,4,))

" wrote:
Hi,
I'm hoping someone can help me out with what should be an easy task,
but I can't quite get it.
I'm trying to do a Vlookup for 2 columns (either/or) using this
formula:

=VLOOKUP(OR(A18,B18),data1,4,FALSE)

where 'data1' is my array on a separate sheet. *It works fine for a
single vlookup, but no luck using the 'or' function.

Does anyone know how to do this?
Thanks in advance for any replies.

Terry

Thanks Teethless Mama! That worked exactly like I needed!

Vlookup with either/or
 

You're Welcome!

"TH" wrote:

On Sep 17, 11:16 am, Teethless mama
wrote:
=IF(COUNTIF(data1,A18),VLOOKUP(A18,data1,4,),VLOOK UP(B18,data1,4,))

" wrote:
Hi,
I'm hoping someone can help me out with what should be an easy task,
but I can't quite get it.
I'm trying to do a Vlookup for 2 columns (either/or) using this
formula:

=VLOOKUP(OR(A18,B18),data1,4,FALSE)

where 'data1' is my array on a separate sheet. It works fine for a
single vlookup, but no luck using the 'or' function.

Does anyone know how to do this?
Thanks in advance for any replies.

Terry

Thanks Teethless Mama! That worked exactly like I needed!