Jun 19 2019 05:02 AM
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.
Jun 19 2019 05:20 AM
Jun 19 2019 08:00 AM
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)
Jun 19 2019 08:39 AM
That's with some VBA programming. Check, for example, this https://www.youtube.com/watch?v=nly6te4Wt9Q
Jun 19 2019 06:08 PM
Jun 20 2019 01:05 PM
Hello @JeroenvVliet,
If you want to avoid VBA, you could always apply a filter to your list and filter by color.
Hopefully this helps!
Jun 20 2019 01:29 PM
I guess the result shall be return to another cell. You manually mark the cell by color (not necessary to find it) and value of that cell is used in another place.