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?