I am needing a function that uses the data in cells n10-12 to return the right number from the chart into cell n14. i have placed the correct number in n14 for reference
I am needing a function that uses the data in cells n10-12 to return the right number from the chart into cell n14. i have placed the correct number in n14 for reference
I have closed your duplicate thread. If you would like this thread moving, please ask.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
sorry abobut that.
the correct return should be 122030110
There is no number in N14, so we don't know what the formula is meant to return.
Pete
Are you still using an old version of Excel? There is no 2017 version - what do you have?
i am now using microsoft 365
Thanks for updating your profile.
You can use this formula in cell N14:
=INDEX($E$4:$K$39,MATCH(N10,$B$4:$B$39,0)+MATCH(N12,$C$4:$C$7)-1,MATCH(N11,$E$2:$K$2))
Hope this helps.
Pete
That works thank you for the help Pete.
You're very welcome. Thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks