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