Good afternoon
This is the first time I am using xlookup multiple criteria
I was able to get xlookup working when using all the data and results on the same sheet when I tried to get information from 2 different sheets excel is showing #VALUE! error
I am not sure why the information is not working when I add a 2nd sheet any help would be great
Working formula from 1 sheet
=XLOOKUP($I$2&I3,$C$4:$C$1000&$D$4:$D$1000,$G$4:$G$1000)
Not working Formula from 2 sheets
=XLOOKUP($D$1&C3,'Customerset Ti-Hi'!C4:C1000&'Customerset Ti-Hi'!D5:D1000,'Customerset Ti-Hi'!G5:G1000)
I have attached a sample file
Sheet Planning cell J3 is formula that is giving error Cells J5,J6,J7 are sample results
Sheet Customerset Ti-Hi cell L5,L6,L7 are working formualas
Thank you for your time
JustinwB
Bookmarks