Home > Software engineering >  How to use VLOOKUP() QUERY() IMPORTRANGE() with mutiple conditions?
How to use VLOOKUP() QUERY() IMPORTRANGE() with mutiple conditions?

Time:09-07

I currently have this one working fine with 01 condition, but I can't manage to include another criteria:

=Arrayformula(if(A3:A="","",IFNA(vlookup(E3:E,QUERY(IMPORTRANGE("1gh5w0czg2JuoA3i5wPu8_eOpC4Q4TXIRhmUrg53nKMU","Arrayformula VLOOKUP multiple columns!A1:C"), "select Col1, Col2, Col3 label Col3 'Qtd'",0),3,0))))

I've started by concatenating A3:A&E3:E, but I don't know how to get the data ranges for comparison in this fashion using QUERY().

Here is the result VS expectation: [![enter image description here][1]][1]

Also, here is an example for tests: enter image description here

  • Related