Nested MATCH

[beternal]

Hi,

Looking to (I believe) 'nest' a MATCH

First part of a very long formula:

=INDEX(Raw_data[[Item1]:[Item10]],MATCH(1,(Raw_data[Week]='Count Heatmap'!N1)*(Raw_data[Net]='Net1'!D4),0),MATCH...

...and I'd like to insert another requirement so that the MATCH above (looking for a week number from a dropdown value in cell N1) acts in conjunction with another dropdown value in Raw_data[Year] from cell CR1


i.e. select the year in cell CR3, select the Week in N1 and the formula works (rather than just at present, selecting the week ONLY)

Any help is appreciated!!!

[Glenn Kennedy]

=INDEX(Raw_data[[Item1]:[Item10]],MATCH(1,(Raw_data[Week]='Count Heatmap'!N1)*(Raw_data[Year]='Count Heatmap'!CR1)*(Raw_data[Net]='Net1'!D4),0),MATCH...

Maybe??? or not???

[beternal]

Thanks Glen, worked perfectly!!

I think you helped me construct all this, so very very grateful with all your help so far.

In a nutshell, this is taking data from a table and translating it into a 2D heatmap of activity. It's really done wonders for my site!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.