Hi,
I need to look up a value across two columns
I.e. I need the vlookup to look for value in column A acrosscolumns B & C and if the value in column A is found in either column B or Cor found in both columns return that value.
<tbody>
</tbody>
I have been working with the below formula but I am justreceiving a #ref / #N/A error.
=VLOOKUP(O:O,MOV!AI:AJ,{20,21},FALSE)
Any help is greatly appreciated.
Thanks,
I need to look up a value across two columns
I.e. I need the vlookup to look for value in column A acrosscolumns B & C and if the value in column A is found in either column B or Cor found in both columns return that value.
A | B | C |
1 | 5 | 1 |
2 | 2 | 2 |
I have been working with the below formula but I am justreceiving a #ref / #N/A error.
=VLOOKUP(O:O,MOV!AI:AJ,{20,21},FALSE)
Any help is greatly appreciated.
Thanks,