Home

Excel Help with what may be a lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-570650%22%20slang%3D%22en-US%22%3EExcel%20Help%20with%20what%20may%20be%20a%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-570650%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20what%20I%20would%20like%20for%20my%20spreadsheet%20to%20do%2C%20but%20I%20am%20not%20sure%20if%20it%20is%20possible.%20I%20want%20it%20to%20take%20the%20values%20in%20Column%20C%20and%20see%20if%20the%20same%20value%20is%20displayed%20in%20BOTH%20Column%20I%20and%20Column%20O.%20If%20the%20value%20is%20in%20displayed%20in%20all%203%2C%20meaning%20the%20value%20in%20C%20was%20found%20in%20BOTH%20I%20and%20O%2C%20I%20want%20it%20to%20return%20something%20like%20%22Have.%22%20I%20also%20want%20it%20to%20tell%20me%20the%20values%20that%20are%20the%20same%20in%20both%20I%20and%20O%2C%20but%20are%20not%20present%20in%20C.%20Is%20this%20possible%3F%20I%20have%20done%20lots%20of%20research%2C%20but%20been%20unable%20to%20find%20a%20way.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113409i9C8241744544A251%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-05-15%20at%203.18.33%20PM.png%22%20title%3D%22Screen%20Shot%202019-05-15%20at%203.18.33%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-570650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-571098%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20what%20may%20be%20a%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571098%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Excel%20function%20for%20your%20requirements%20is%20MATCH().%26nbsp%3B%20It%20works%20nicely%20for%20exactly%20what%20you%20are%20doing.%26nbsp%3B%20Of%20course%2C%20you%20will%20build%20a%20formula%20with%20a%20couple%20of%20MATCH()%20functions%20and%20an%20IF.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-571127%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20what%20may%20be%20a%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342686%22%20target%3D%22_blank%22%3E%40MMMM1-1%3C%2FA%3E%26nbsp%3B%2C%20for%20the%20first%2C%20if%20you'd%20like%20to%20have%20the%20flag%20against%20each%20value%20in%20C%2C%20when%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF(COUNTIFS(I%3AI%2CC2%2CO%3AO%2CC2)%2C%22have%22%2C%22%22)%3C%2FPRE%3E%0A%3CP%3Eor%20you's%20like%20to%20generate%20the%20list%20of%20such%20values%3F%20Same%20question%20about%20second%20case%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Here is what I would like for my spreadsheet to do, but I am not sure if it is possible. I want it to take the values in Column C and see if the same value is displayed in BOTH Column I and Column O. If the value is in displayed in all 3, meaning the value in C was found in BOTH I and O, I want it to return something like "Have." I also want it to tell me the values that are the same in both I and O, but are not present in C. Is this possible? I have done lots of research, but been unable to find a way. Screen Shot 2019-05-15 at 3.18.33 PM.png

2 Replies

The Excel function for your requirements is MATCH().  It works nicely for exactly what you are doing.  Of course, you will build a formula with a couple of MATCH() functions and an IF.

 

@Deleted , for the first, if you'd like to have the flag against each value in C, when like

=IF(COUNTIFS(I:I,C2,O:O,C2),"have","")

or you's like to generate the list of such values? Same question about second case

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies