←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to xlookup multiple values?

Our take

Struggling with retrieving multiple values from a pivot table can be frustrating, especially when dealing with varying date entries. If you're looking to seamlessly extract values based on specific criteria like Date and Item #, you’re not alone. Fortunately, XLOOKUP offers a straightforward solution that simplifies this process. In this guide, we’ll walk you through the easiest and most efficient method to accomplish this task, ensuring you can confidently populate your blank table with the correct data.

How to xlookup multiple values?

Hi everyone, I am trying to look up values from a pivot table by both Date (top row highlighted blue) and Item # (left column highlighted blue), and return the corresponding value (highlighted yellow) from the pivot table, into my blank table in the first screenshot. I can’t just paste the rows in because the date values skip some days in the pivot table (e.g. between column E-F the date jumps from 9/5 to 9/10).

Actual item #s are redacted but you get the idea

I’ve tried xlookup and index/match but it was sort of confusing so I think I screwed it up. What is the easiest and most economical way to do this?

https://imgur.com/a/ZMQgP0X see 2 screenshots

submitted by /u/PayNo6808
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#rows.com