Why is this Arrayformula based vlookup with multiple criteria is not working?

user_11832197 0
Viewed 45

I've followed the instruction, but it doesn't work in my situation and I wonder why.

This is the formula:

=ARRAYFORMULA(VLOOKUP(B12&""&C12,F11:H29,3,0))

Here's a doc with a situation for tests: File

Thanks!

vlookup google-sheets-formula google-sheets if-statement filter
3 Answers

No helper column all at once

Paste this in K11 Sheet Example

=ArrayFormula(IF(G12:G="",,VLOOKUP({F12:F&" "&G12:G},{{F12:F&" "&G12:G}, E12:E} ,2,0)

))

enter image description here

With helper

Try this. add a helper column with the formula G11&" "&H11, and paste the following formula in K11

=VLOOKUP(B12&" "&C12,F11:I29,4,0)

enter image description here

user_195296940

try:

=ARRAYFORMULA(IFNA(VLOOKUP(B12:B29&C12:C29, {F11&G11, H11}, 2, 0)))

enter image description here

user_56326290

If 1Item A and Cabeça do not change, you can even hardcode them to avoid any helpers.

=INDEX(IFERROR(VLOOKUP(B12:B29&C12:C29, {"1Item A", "Cabeça"}, 2, 0)))
user_15277800
Related