'Excel VLOOKUP not matching multiple values
I'm trying to make an expandable formula to match values from 3 columns to a table that has 4 columns, and take the 4th value of the matched row:
Table 1:
A B C
0 1 0
1 0 1 <-- matching this row
1 1 0
Table 2:
D E F G
0 0 0 1
1 0 1 0.5 <-- expecting 0.5
1 1 1 1
And I'm using this test formula for VLOOKUP:
=VLOOKUP(A2&B2&C2, $D$1:$G$3, 4)
This however returns N/A even though 1 0 1 exists in Table 2
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
