Hey guys,

I am trying to create a formula that will lookup a value from a cell in a table and then look at a cell that is relative to that position.

I.e. If it finds the value "1" in a cell, it will look in the first column of the table for the value "1" and once it finds it, get the reference of the cell three cells to the right of it (i.e. if 1 is in cell A1, return the value "A4" for use in another formula.)


I hope I have explained that well enough for you to understand and help!

Thank you for any help you can offer,

Rich