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:

CodePudding user response：

No helper column all at once

Paste this in K11

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)

CodePudding user response：

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)))