Looking up 2 variables

[notaexcelexpert]

Hi,

 please see attached.

I want to lookup the reference AND amount from S/S A on S/S B. then return the "bank date" .  

I've tried using vlookup but this only allows you to lookup one variable at a time. is there a formula to lookup two?

Thanks

[#2]

@notaexcelexpert 

=IFERROR(VLOOKUP(E3&F3,CHOOSE({1,2},$A$3:$A$24&$B$3:$B$24,$C$3:$C$24),2,0),"")

You can try a formula with VLOOKUP and CHOOSE as shown in the example. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.