VLOOKUP Formula in Excel is used when you have a specific item you'd like to lookup in a table & there is only 1 of that item in the table i.e. it is unique