'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