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.
Hello JeroenvVliet,
If you want to avoid VBA, you could always apply a filter to your list and filter by color.
Hopefully this helps!
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.