Forum Discussion
Looking up 2 variables
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...
=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.