vlookup to one row BELOW the looked up value

[Berrett]

I have merged cells in column A - imagine my name merged down from A1 to A3.
Then I have data in B1, B2, and B3.

On another sheet I have a vlookup that's looking for my name. A regular vlookup finds my name in the merged cells and returns the value from B1. But how do I write a vlookup that will return the values from B2 and B3?

 

[ajamess]

Use index/match. I'm going to assume your lookupvalue is in c1, replace as appropriate:

=index(b:b,match(c1,a:a,0)+1)

=index(b:b,match(c1,a:a,0)+2)

First one returns B2, second one returns B3.

 

[Berrett]

Thank you ajamess! That totally worked. I really appreciate the quick response!