Home

Using excel with INDEX AND MATCH to read out a summary

%3CLINGO-SUB%20id%3D%22lingo-sub-706217%22%20slang%3D%22en-US%22%3EUsing%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-706217%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%20i%20have%20included%20a%20document%20(a%20summary).%20The%20yellow%20lighted%20value%20is%20the%20value%20that%20i%20want%20to%20search%20with%20formula's.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20and%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-706217%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-706302%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-706302%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20explain%20what%20you%20mean%20when%20you%20say%20you%20want%20to%20search%20for%20the%20value%20with%20formulas%20please%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-707421%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707421%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWhat%20I%20mean%20is%20how%20do%20I%20use%20the%20functions%20index%20and%20match%20(or%20an%20other%20function%20that%20is%20needed%20to%20do%20this)%20to%20locate%20the%20yellow%20hightlighted%20result%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20need%20to%20know%20this%3CBR%20%2F%3EHopefully%20you%20could%20help%20me.%3CBR%20%2F%3ESee%20the%20document%20that%20was%20uploaded%20with%20this%20question%20(you%20will%20see%20a%20yellow%20result)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-707563%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362845%22%20target%3D%22_blank%22%3E%40JeroenvVliet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20some%20VBA%20programming.%20Check%2C%20for%20example%2C%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dnly6te4Wt9Q%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dnly6te4Wt9Q%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-709257%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-709257%22%20slang%3D%22en-US%22%3ESorry%2C%20that%20sort%20of%20thing%20isn't%20possible%20with%20built%20in%20formulas%2C%20you%20will%20need%20to%20check%20out%20the%20video%20that%20Sergei%20posted%20a%20link%20to.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712038%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712038%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362845%22%20target%3D%22_blank%22%3E%40JeroenvVliet%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20avoid%20VBA%2C%20you%20could%20always%20apply%20a%20filter%20to%20your%20list%20and%20filter%20by%20color.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712088%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20excel%20with%20INDEX%20AND%20MATCH%20to%20read%20out%20a%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20the%20result%20shall%20be%20return%20to%20another%20cell.%20You%20manually%20mark%20the%20cell%20by%20color%20(not%20necessary%20to%20find%20it)%20and%20value%20of%20that%20cell%20is%20used%20in%20another%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JeroenvVliet
New Contributor

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.

6 Replies
Hi

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)

@Wyn Hopkins 

@JeroenvVliet 

 

That's with some VBA programming. Check, for example, this https://www.youtube.com/watch?v=nly6te4Wt9Q

Hello Friends, In this video you will learn how to create your own VLOOKUP function in excel to get the value by cell back ground color. Syntax of the formula will be same as original VLOOKUP. Range lookup (0 and 1) also can be used. You can download this excel file from below given link: ...
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.

Hello @JeroenvVliet,

 

If you want to avoid VBA, you could always apply a filter to your list and filter by color.

 

Hopefully this helps!

@PReagan 

 

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies