Forum Discussion

JeroenvVliet's avatar
JeroenvVliet
Copper Contributor
Jun 19, 2019

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.
excel
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jun 19, 2019
Hi

Can you explain what you mean when you say you want to search for the value with formulas please
  • JeroenvVliet's avatar
    JeroenvVliet
    Copper Contributor
    Jun 19, 2019

    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)

    Wyn Hopkins 

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jun 19, 2019
      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.