This is my first query - please help.
Sheet2 contains table of values. B5:F8
The offset of F from B is known(4)
Sheet1 C5:C8 has simple lookup in =Sheet2!B5 etc to =Sheet2!B8
My Requirement
Formula in Sheet1 E10:E13 to refer to Sheet1 C5:C8 value but with the known offset.
e.g. The formula in Sheet1 E10 should return JOAN.
An example xlsx is attached.
Thank you.
Bookmarks