HLOOKUP formula in Excel is used when you have to lookup specific item in a table & there is only one of that item in the table i.e. it is unique