When carrying out data analysis with VLOOKUP it’s generally critical that the data being used has unique values.

Use & or CONCATENATE to combine cell contents and use these multiple cells (including additional text if needed), to create new cell value.

to fill out a cell using contents of one and appending from another

e.g. to create new value A1B12

A B C < C using ‘&’ > < C using CONCATENATE >
1 Jason Dorsett JasonDorsett =A1&B1 =CONCATENATE(A1,B1)

Specified text can be added between “”

e.g. to create new value A1_B12

A B C < C using ‘&’ > < C using CONCATENATE >
1 Jason Dorsett Jason_Dorsett =A1&”_”&B1 =CONCATENATE(A1,”_”,B1)

You can extend the function as needed using multiple text entries and cells

e.g. to create new value A1_B12

Car = Ford Escort – Red use

="Car = "&A1&" "&B1&" - "&C1
A B C D < D using ‘&’ > < D using CONCATENATE >
1 Ford Escort Red Car = Ford Escort – Red =”Car = “&A1&” “&B1&” – “&C1 <=CONCATENATE("Car = ",A1," ",B1," - ",C1)
2 Lotus Elise Silver Car = Lotus Elise – Silver =”Car = “&A2&” “&B2&” – “&C2 =CONCATENATE(“Car = “,A2,” “,B2,” – “,C2)
3 BMW 330 Blue Car = BMW 330 – Blue =”Car = “&A3&” “&B3&” – “&C3 =CONCATENATE(“Car = “,A3,” “,B3,” – “,C3)
4 Audi Car = Audi – =”Car = “&A4&” “&B4&” – “&C4 =CONCATENATE(“Car = “,A4,” “,B4,” – “,C4)
5 Mini Cooper Blue Car = Mini Cooper – Blue =”Car = “&A5&” “&B5&” – “&C5 =CONCATENATE(“Car = “,A5,” “,B5,” – “,C5)