I am doing a Vlookup search across data that contains several parameters. I have created a unique key to do the vlookup against, using the concatenation of say A1 and B1. However, the problem is that there are duplicate keys using this format, but the rest of the parameters can be different (cells C1 to ZZ1, etc). so when i do a vlookup on my cell, and search to pull in what column C has, only the first match is returned.
Is there a way to differentiate that in the Vlookup so if my concatenation of A1B1 brings back C1, I want A2B2 to bring back C2, even if A1B1 = A2B2.