Forum Discussion

notaexcelexpert's avatar
notaexcelexpert
Copper Contributor
Aug 07, 2023

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 at a time. is there a formula to lookup two?

 

Thanks

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 07, 2023

    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.

     

Resources