VLOOKUP FUNCTION?

[jpalleyne]

I need a formula to return the ref # from table #2 so I have the ref # in table #1. I'd need the formula to be based on date and and amount as those would be the only unique identifiers given that the numbers have the potential to repeat themselves, that's where the date criteria would come in but there's still a chance that the same number will be present on that particular date. I was trying VLOOKUP/MATCH with no luck.
Any help would be appreciated.

​

Table #1

Date​	Details​	Amount​	Ref #​
01/03/2023​	Digital- SOUTH COAST DENTmed i​	2,368.26​	?​
​	​	​	​

​

Table #2

Date​	Details​	Amount​	Ref #​
01/03/2023​	Wire Transfer	2,368.26​	12614​
​	​	​	​

 

[jpalleyne]

Range	Formula
D3:D8	D3	=XLOOKUP([@Date]&[@Amount],Table2[Date]&Table2[Amount],Table2[Ref '#])

Okay will do next time. I'm not getting the results you did. Is there more to the XLOOKUP that's needed?

 

[Peter_SSs]

As I said in my previous post, I don't think that XLOOKUP formula is robust and I posted what I believe is a better version in my second mini sheet in my previous post.

If you are not getting the correct results then use XL2BB to post some small sample data that is showing incorrect results and tell us which results are incorrect and what the correct results should be and why.