•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to xlookup multiple values?
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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#xlookup
#pivot table
#values
#Date
#Item #
#corresponding value
#blank table
#index/match
#economical way
#look up
#highlighted yellow
#data skips
#screenshots
#confusing
#redacted
#retrieve