Of all lookup functions, HLOOKUP is among the least famous ones.

It looks up a value in the first row and returns any corresponding item in another row.

Look up value MUST be in the top row of a table.

How do you make it return multiple items?

It’s default setting is to return a single value

Using the data below, how do you return the least expensive suppliers per item quoted?


  1. To return multiple items you need to use the column value as a lookup value
  2. You need to create a table array where the Column Values are on the top row
  3. You need to loop through column values one at a time


Watch the Full Video on LOOKUP functions Returning Multiple Items

Do you want to excel in Excel?


Seeking Microsoft Certification?

Every Week Receive Resources To Get you Closer to Your Goal!

No Huff! No Fluff! No Spam!

You are on your way to Excelling in Excel and Becoming Microsoft Certified!

Share This

Spread the Good News!

Do me favour, please? Share this with your friends!

Thanks For Commenting!

Awesome for you to comment! Please share the post with your friends.