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...
JestersQuest Your formula looks OK and works for me. I replicated your example in the attached workbook.
Riny_van_Eekelen thank you for taking the time to help me with this. I still couldn't get it to work, but your test sheet made me realize that Data!I:I was looking in the Data sheet, but J:J was still looking in the current sheet (which didn't have the info I wanted to return). So I was able to test and fix my formula by adding Data!J:J. Much appreciated!
Original Formula
=XLOOKUP(C2,Data!I:I,J:J)
Corrected Formula
=XLOOKUP(C2,Data!I:Data!I,J:J)
JestersQuest Glad you could figure it out!