Lookup OR Index/Match with multiple Array's

Dear All,

I'm facing another problem within my worksheet, Below I made a similiar example of what I try to acquire...
I need to lookup for EACH year the results if a system (dropdown list in cell B28) is OK or NOT OK, but it also needs to look at what site (Dropdown list in cell C28 )

I tried initially with VLOOKUP($B$28;$B$4:$Q$4;2)...VLOOKUP($B$28;$B$4:$Q$4;3)...VLOOKUP($B$28;$B$4:$Q$4;4)...
and this works, but only for one array and one look up value at a time.

Is there a way where I can use INDEX/MATCH or CHOOSE to work with the 2 values to look up at?

Thanks in Advance
Numnum

Pl see file.

It will be easier if you made the spacing between the three tables the same, so delete row 10 so that your drop-downs are now in B27 and C27. Then you can use this formula in C28:

=INDEX($C$3:$Q$26,MATCH($C$27,$B$3:$B$26,0)+MATCH($B$27,$B$4:$B$8,0),MATCH(B28,$C$3:$Q$3,0))

and then copy it down.

Hope this helps.

Pete

You will get the #N/A error if there is not an exact match - it might be that you have dates formatted to show the year rather than actual years. There is no limit to the actual size of the INDEX array.

I can only work from the sample that you attach, so if your real data contains months then post an example of that file (remove anything that is confidential first).

Hope this helps.

Pete