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...
You appear to referencing an entire column on the 'Data' sheet but then returning a cell from the formula sheet.
Edit:
Sorry, I failed to open the discussion up to see the later comments 😞