Need offset data from multiple match

[SCDE]

I am struggling trying to get data by matching against a table that the data changes columns and rows each time the report runs.

The top table is data from a report that is added from code that I wrote. The bottom table is actually a helper table to pull the data to feed other sheets. From the bottom table, I need to match the department and name to the department and name on the top table to get the desired results. Thanks for the help.


Capture21.JPG


Project1.20.2015.xlsx

[samba_ravi]

D15=INDEX(INDEX($A$2:$N$11,0,MATCH(A$14,$A$2:$N$2,0)+3),MATCH(B15,INDEX($A$2:$N$11,0,MATCH(A$14,$A$2:$N$2,0)+1),0))
Try this and copy across

if it is not you are looking for, pls elaborate your requirement

[SCDE]

I tested your formula on a copy of my actual data and it worked perfectly. Thanks for your help.