User Profile
JestersQuest
Copper Contributor
Joined Feb 14, 2020
User Widgets
Recent Discussions
Re: Connect XLOOKUP to Data on Different Sheet
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)132KViews1like1CommentConnect 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 perfectly. That same data on another sheet returns 0.0. I just can't figure out what I'm doing wrong! What works: =XLOOKUP(C4,I:I,J:J) What doesn't work: =XLOOKUP(C4,Data!I:I,J:J) Please help! What am I doing wrong? Or is it not possible to connect to data on another sheet? Thanks!139KViews1like6Comments
Recent Blog Articles
No content to show