Just remember the principles of a vlookup and it becomes a whole lot easier. You are trying to look up a reference, either a fixed (i.e. typed in) or a cell and you are trying to find that in the left most column. Then you are looking to return a value X columns away.

Simply speaking if you were looking for “Car” in this table

Car 1
Bike 2
Train 3

You would look for “Car”, in the above table, 2 columns along. This would look like = vlookup(“Car”,A1:B3,2,false). This assumes the table starts in cell A1. The false at the end means find the exact reference.

If you have any other questions just shout.