In the past I have concatenated multiple columns and performed the vlookup on the concatenation. Depending on the data, the concatenation is often a unique value.
Using your example, you would get values of:
1234510
12345123
1234567
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.