Forum Discussion
Cell reference in formulas
I have a large report that has 13 columns and 300+ rows that I converted to a table. I'm trying to extract multiple data items from that table to build a new, smaller report. I'm trying to use XLOOKU...
Thank you, matheletics. I did resolve my original Q, but it did me to the place I wanted to be. I'm trying to narrow down my search in a large database to on line, that I will then pick information off of, and repeat the process offering different variables. I'm trying to use XLOOKUP, with boolian perameter, but I'm afraid I've lost my way...I keep getting N/A errors 😞 Anyway, 10 hours is enough for one day. Thanks again.
You haven't described the full context here, so this may be wide of the mark, but reading what you've written, I wonder if you're aware of the still relatively new Dynamic Array Functions, UNIQUE, FILTER, SORT.... I've found in many situations that FILTER, in particular, can do a lot of what XLOOKUP and its various _LOOKUP cousins (including INDEX and MATCH, XMATCH) can do, and do those selections more powerfully and neatly.
Here's a great YouTube video that introduces the Dynamic Array Functions to the world. You do need Excel 2021 or newer to use these.