Vlookup with offset on return

Hi,

I'm trying to use a vlookup to return a value 1 row below the normal return cell and have tried numerous embedded offset formulas in both vlookup and index match but cannot get it to work.

The problem is that a report that is generated is off kilter and to avoid going in to reformat the data I just wanted to write the offset in to the formula

Capture.JPG

For example I want the formula to look up the word White but return the value from the 6th row which is 18.

From my searches online I haven't found any posts which solve this problem so I would really appreciate any help.

Thanks

Try

=INDEX(B3:B7,MATCH("White",A2:A6,0))

Notice the 1 row offset of the 2 ranges, that's intentional.

Thank you very much for your replies - All spot on and worked a treat

You're welcome.