Index Match in Named Ranges

[JonesyUK]

Hi All,

Need some formula help please:

1) I have 12 "cubes"/ranges of data (1 for each month) on a single sheet
2) Each "cube" of data is a named range, eg. "Jan_Act", "Feb_Act", "Mar_Act" etc...
3) First row of each range contains headings which are unique names (about 200 columns)
4) First column of each range contains headings which are account categories (about 300 rows)

I am trying to do a sort of Index Match formula on a separate sheet ("Lookup") which looks for the row & column combination that is specified in cell A1 ("unique name") and cell B1 ("account category") and cell C1 ("month")

Example:
Lookup Sheet
A1 = Name20
B1 = Fuel Costs
C1 = Feb_Act

Need a formula to return the number that meets those criteria, i.e. look in cube called "Feb_Act", find "Name20" in first row of range and find "Fuel Costs" in first column of range

Hope this makes sense, and thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.