Good morning all!

test.xlsI've attached a small workbook which I hope might help better explain what I need to be able to do. In short I have the column address of one value (the name) and want to use this column address number to look up the value in coluimn before the equivalent column (where the address value is greater than 1) under the VALUES half of my data.

For example, on the spreadsheet where it says Mike, I need to come up with a formula that returns the value of 900 from cell A2.

Does that make sense to any of you?