vlookup ONLY used the 1st column in the range, so you still need to combine those 3, inside the MATCH
A B C D E F G 1Data table 60060127 260060127 2589315470 76.65 60060127 2589315470 76.65 11 2589315470 360060127 2589315470 33.53 60060127 2589315470 33.53 12 33.53 4 5 12using INDEX/MATCH 6 12using helper and vlookup
A2=B2&" "&C2&" "&D2
B5=INDEX(E2:E3,MATCH(G1&" "&G2&" "&G3,INDEX(B2:B3&" "&C2:C3&" "&D2:D3,0),0))
B6=VLOOKUP(G1&" "&G2&" "&G3,A2:E3,5,0)
Bookmarks