šŸ“©: [email protected]: [email protected]: [email protected]

 

How to Use Multiple Criteria in a VLOOKUP function

by | Dec 26, 2022 | INTERMEDIATE EXCEL | 0 comments

Many users think you cannot use multiple criteria in a VLOOKUP Function, but this is wrong.

=VLOOKUP(
     G2&H2,
     CHOOSE(
          {1,2},sales[Name]&sales[Region],sales[Date])
     ,2,FALSE)

DOWNLOAD WORKSHEET

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Do you want to excel in Excel?

Or

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.