Forum Discussion
Connect XLOOKUP to Data on Different Sheet
I love the new XLOOKUP to replace my many Index Match formulas, but I can't seem to connect XLOOKUP to data on another sheet. If the data is on the sheet with the XLOOKUP formula, everything works pe...
I am having somewhat of the same issue. I have sheet 1 with all the information I need however when i try to populate the data from sheet one it gives all my items the same order number instead of the different order that it is connected to. Example: Order X has different items but the same order. This only pulls one item and not multiple items.
K_eastman If your question is about why XLOOKUP only returns one value, the answer is "that's by design". If you want to return all relevant records for a particular order number you need to use the FILTER function.
