'Excel Match function: Lookup of multiple values in multiple lookup arrays not working when there is just one row in the lookup array [duplicate]
I want to lookup three lookup values in cells A8, B8 and C8 in table columns Number1, Number2 and String1. This is the formula I am using:
=MATCH(A8&B8&C8,tbl[Number1]&tbl[Number2]&tbl[String1],0)
It works fine, when I have multiple rows in the lookup array. But I get a #VALUE! error when there is just one row.
Not working:
Working:
It looks fine when I evaluate the formula, but Excel does not seem to recognize the second "12a" as an array:
Can this problem be avoided and the formula improved?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|