Forum Discussion
Solved
Help pulling information from one tab to another.
I am trying to get information to pull from one tab to another and having issues. I believe it is because there can be multiple responses. I am trying to pull information based on table number. I hav...
Excel's lookup functions (LOOKUP, VLOOKUP, XLOOKUP) are designed to return a single value (or with adjacent values, in some cases). To return data from (possibly) more than one row, you should use Excel's FILTER function. See the attached workbook.
Excel's lookup functions (LOOKUP, VLOOKUP, XLOOKUP) are designed to return a single value (or with adjacent values, in some cases). To return data from (possibly) more than one row, you should use Excel's FILTER function. See the attached workbook.
Thank you! this is exactly what I was hoping for.