This video looks at how to use the VLOOKUP function when you need to join or concatenate values in separate columns in your lookup table to create a unique reference. Instead of having to create an additional column where you perform the concatenation you can use the CHOOSE function to create and define the columns in your lookup table. Video assume a working knowledge of VLOOKUP and concatenation.
------------------------