How do I create a Venn diagram in Numbers (iOS)?

so you are looking in column A for that row, and bringing back what row in column B has a match, if any.

There are a few ways to do what your asking, here is one that I think is the simplest to understand when I was starting with this kind of thing.

In the formula below we concatenation th letter B with the results of the match to bring back the string “B5”. Which is where we found the word juice in column B for row 7 in A. But a formula cannot use a string “B5” it needs the cell reference B5. So we throw that entire concatenation into the indirect function. Indirect converts a string that “looks” like a cell reference and converts t into a real one That number can use.

If if you want to look at another method, you can look up the offset function it’s really useful as well.

Help on on all these functions can be found from within the program itself, or online if you was click this link. (It says numbers ‘09 but the formulas haven’t changed )

hope this helps

jason

I was about to give you the same answer as the linked solution you already gave, since the solution on the other post doesn’t have the “S” you are showing, I think you might have an error in your formula.

if you can post a screen shot of your existing formula, we might be able to tell you how to change it to bring back the data being duplicated and not the text you are seeing.

jason