APPLYING HORIZONTAL LOOKUP IN MICROSOFT EXCEL

In my last blog, I wrote about how to use vertical lookup in Excel. I will be writing on how to use horizontal lookup in this blog.

Photo Credit: Google

• HLookup function which stands for horizontal lookup is used to search for a certain value in a row in order to return a value from a different row but the same column. It finds and retrieve a value from data in a horizontal table.
• The decision on whether to use a VLookup or HLookup depends on the arrangement of the table.
• We are going to use the same dataset from my previous blog which I got from kaggle titled wine rating and price (link to the dataset will be given below the write-up)
• From the dataset titled Red as used in my previous blog, I used the first 100 rows from the dataset.
• Because we are dealing with HLookup, we will have to transpose the data. To do this copy the data (the first 100 rows in my case) and use the “paste special” option instead of normal paste option to paste, then tick the transpose box. After doing this, the data will be arranged horizontally.
• Click the link below to see how I transposed the data:

Bajisma Ace Mary on LinkedIn: #excel #lookup #transpose

Below are the next steps to take:

1. Write the name of the wine to be searched for in a stand alone cell in the spreadsheet (Merlot 2018). (In my case, the cell I wrote the wine name is Cell C13)
2. In a new cell where you want the price found to be pasted, write the formula: = HLOOKUP(C13, A1:CZ8, 7, FALSE)

Picture depicting HLookup formula

• A1:CZ8 represents the total original data in the spreadsheet after transposing without the stand alone cells created.
• 7 represents the row index number of Price row (Price row is located in row number 7).
• False symbolizes exact match while True symbolizes approximate match, we need an exact match hence we use False.

3. If the formula is written correctly, you will get the exact price of the wine.

PS: This formula that has been written will automatically get you the price of any other wine so far the wine name is typed inside the C13 cell.

For crosschecking the price with the price the HLookup function gave, you can check column BD (where Merlot 2018 is located).

Link to dataset: https://www.kaggle.com/datasets/budnyak/wine-rating-and-price

If while learning, you feel the need to ask questions for clarity, you can send me a mail @marybajisma123@gmail.com or contact 09021833246.