Forum Discussion
Using excel with INDEX AND MATCH to read out a summary
Hi guys, i have included a document (a summary). The yellow lighted value is the value that i want to search with formula's. Please help me and thank you.
Hi
Can you explain what you mean when you say you want to search for the value with formulas please
Can you explain what you mean when you say you want to search for the value with formulas please
Hi
What I mean is how do I use the functions index and match (or an other function that is needed to do this) to locate the yellow hightlighted result?
I really need to know this
Hopefully you could help me.
See the document that was uploaded with this question (you will see a yellow result)
- Sorry, that sort of thing isn't possible with built in formulas, you will need to check out the video that Sergei posted a link to.
That's with some VBA programming. Check, for example, this https://www.youtube.com/watch?v=nly6te4Wt9Q
