@@rupert86 Hey there, I made a custom video first to see if this helps with your question. Please let me know =) Video link: ruclips.net/video/YodvgTDCMjI/видео.html
Please lets say i want to get the index of candy type of sour 210 how do u go about it. Thats trying to find the label area of the values. Its like the other way round this time
Hey there, so in your example based on the video are you wanting to replace the candy store dropdown with a sales figure? Apologies if I am a bit lost, trying to make sure I understand your question.
@@CareerSolutionsforTodayokay thanks for your response. So I want a situation where if I choose taffy, with 180 I'll get the answer of candy baron. Like I want to get the value of the label area if I'm giving the type and amount or quantity.
@@amandakennedy6895 Hey there, so to find the solution you are looking for with this same table, you would switch cell C3 to candy type "taffy" and switch cell C4 to number sold "210". Then in cell C5 you can enter the function: =INDEX(B7:D7, MATCH(C4, INDEX(B8:D11, MATCH(C3,A8:A11, 0), 0), 0)) And this will return the candy store name based on sales and candy type. Let me know if this helps.
Thanks, can you make one with 2 sheets? Your way of explanation is very easy to understand.
Hey there, thank you for the comment. Do you mean showing Index and Match between 2 sheets?
@@CareerSolutionsforToday yes. Thanks
@@rupert86 Thanks, if I make the video are you ok with me showing your comment as suggesting the idea? Let me know =)
Either way no worries.
@@CareerSolutionsforToday absolutely
@@rupert86 Hey there, I made a custom video first to see if this helps with your question. Please let me know =)
Video link: ruclips.net/video/YodvgTDCMjI/видео.html
Please lets say i want to get the index of candy type of sour 210 how do u go about it. Thats trying to find the label area of the values. Its like the other way round this time
Hey there, so in your example based on the video are you wanting to replace the candy store dropdown with a sales figure? Apologies if I am a bit lost, trying to make sure I understand your question.
@@CareerSolutionsforTodayokay thanks for your response.
So I want a situation where if I choose taffy, with 180 I'll get the answer of candy baron.
Like I want to get the value of the label area if I'm giving the type and amount or quantity.
@@amandakennedy6895 Hey there, so to find the solution you are looking for with this same table, you would switch cell C3 to candy type "taffy" and switch cell C4 to number sold "210".
Then in cell C5 you can enter the function: =INDEX(B7:D7, MATCH(C4, INDEX(B8:D11, MATCH(C3,A8:A11, 0), 0), 0))
And this will return the candy store name based on sales and candy type. Let me know if this helps.