Member-only story
HLOOKUP is a powerful function in Excel used to search for a value in the first row of a table and return a value in the same column from a specified row. It stands for horizontal lookup because it searches horizontally across the first row of the table.
In order to demonstrate how to use HLOOKUP, I have made a small horizontal lookup table that can be used to look up the star rating of the delivery priority of an order:-
The order quantities of the spreadsheet are selected at random by placing the following formula in cells A2 to A21:-
=RANDBETWEEN(1,60)
The order priority is manually entered into the spreadsheet from cells C2 to C21.
The star rating is determined by using HLOOKUP on the horizontal lookup table that I had previously created. I have entered the following formula in cells C2 to C21:-
=HLOOKUP(B2,$E$2:$I$3,2,FALSE)
Although the above example is the depiction of a simple spreadsheet, it is an accurate demonstration of how to use HLOOKUP to find the exact wording of a cell.
I have created a code review to accompany this blog post, and it can be found here:- https://youtu.be/_sC8LzISci0
