Vlookup with 3 criteria

[onbeillp111]

I am trying to return a value with 3 lookups from vlookup.

This is what I tried

Please Login or Register  to view this content.

Data table

60060127	2589315470	76.65	11
60060127	2589315470	33.53	12

Trying to match 60060127, 2589315470, 76.65 and return 11. When I use the formula above, I get #N/A

Any ideas??

[FDibbins]

Maybe a better way would be to use a helper column to combine those 3, then use that as the search criteria for the vlookup?
It could also be done with INDEX/MATCH, but if you are not familiar with that, it may be a bit too complex for you

[onbeillp111]

I tried index match formula but I got the same result #N/A

[FDibbins]

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
1		Data table					60060127
2	60060127 2589315470 76.65	60060127	2589315470	76.65	11		2589315470
3	60060127 2589315470 33.53	60060127	2589315470	33.53	12		33.53
4
5		12	using INDEX/MATCH
6		12	using 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)

[onbeillp111]

Thank you, that helped

[FDibbins]

Good stuff
Thanks for the feedback