----------------------------------
----------------------------------
Last edited by Carl_Spackler; 08-14-2017 at 09:49 AM.
It's a bit ugly, 'cos of the data layout (much easier with one block of data, rather than 4). However:
=INDEX($D$7:$AC$9,MATCH(C12,$C$7:$C$9,0),MATCH(E12,$C$5:$AB$5,0)+MATCH(D12,$D$6:$H$6,0)-1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Very odd.... The OP edited the problem out!!!
@Carl_Spackler
Please repost your question, in behave of other forummembers.
With no information (question) the offered solutions of Glenn Kennedy is useless.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Who knows oeldere, even with the info; maybe my effort is useless!!!
@Glenn Kennedy
I did not seen the question or the excel file, but I doubt that.Who knows oeldere, even with the info; maybe my effort is useless!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks