Having some trouble with the logistics of my index match.
Im able to retreive data, but it's showing 0.
here is my formula:
=INDEX(Table3,MATCH($C7,INDEX(Table3,0,1),0),MATCH(G6,INDEX(Table3,1,0),0))
I have attached a sample workbook. I have highlighted in yellow and orange the two data sets im trying to obtain through my index match for a certain person.
your help is truely appreciated.
Cheers
Bookmarks