VLOOKUP function - Shifted search

Hello,

I’m using the VLOOKUP function in a spreadsheet that works with merged cells.
What I need is to retrieve a value from a cell that is not on the same line of the exact match, but lies a couple of cells under it.
Like, the cell I take as dropdown menu is A1, but the result I need is located in B2.
Obviously, the VLOOKUP gets me the result from B1, but I have no idea about how to tell CALC that what I really need is on the right column, but on a different row.

The formula I used is:
=VLOOKUP($H$16;$BN$3:$BV$62;9)

$H$16 locks the list on the dropdown menu.

$BN$3:$BV$62 locks the data field range

9 gets the correct column, but not the right row.

Is there even a WAY to force VLOOKUP to pick the result from a different row or I shall use an entire different formula, if any?

You will use an entirely different formula

=INDEX($BV3:$BV$62;MATCH($H$16;$BN$3:$BN$62;0)+1)

(or it can be ...MATCH($H$16;$BN$3:$BN$62;1)+1... if VLOOKUP without last parameter work for you)

Many thanks!
Sadly can’t upvote your reply >.<

It’s okay, sir, it is enough to mark it as correct :ballot_box_with_check: