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
|