Forum Discussion
jrpeterson
Nov 14, 2022Copper Contributor
Need help with XLookup
Hello, I need some serious help as I've been working on this for days and can't figure it out. I need a search that can look for the data in column A AND in column D in sheet 1 and match that to...
OliverScheurich
Nov 14, 2022Gold Contributor
=XLOOKUP(A2&D2,sheet2!$D$2:$D$18&sheet2!$F$2:$F$18,sheet2!$H$2:$H$18)You can try this formula in order to return amounts from sheet2 column H.
Sheet1:
Sheet2: