Need help with XLookup

Occasional Visitor

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 Column D and F in sheet 2. Once it finds the match I need it to return the amount located in sheet 2 to sheet 1. 

 

I've used Vlookup to find the ref# in Column F on sheet 2, match to Column D in sheet 1 and give me the amount back. But that doesn't always work when the same value is located in column D

 

There should never been the same value in both column D and column A together so I want to search for them both before getting a value returned. I'd attach screenshots I took but can't figure out how.

1 Reply

@jrpeterson 

=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:

sheet1.JPG

 

Sheet2:

sheet2.JPG