Compare two values in an array and if they match in a row, return a value from the third column in the same row.

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I cannot quite get the right ccomination of things to work.

I have a table containing names in column 1, text values in column 2, and totals in column 3.

  A B C
1 Name Text Value Total
2 a Text 1 12
3 a Text 2 4
4 a Text 5 8
5 b Text 2 15
6 b Text 3 3
7 c Text 2 4
8 c Text 3 2
9 c Text 4 1
10 c Text 5 9
11 d Text 1 5
12 d Text 3 5
13 e Text 1 3
14 e Text 2 2
15 e Text 3 8
16 e Text 4 4
17 e Text 5 6
18 f Text 1 4
19 f Text 2 4
20 f Text 3 5
21 f Text 5 3
22 g Text 2 1
23 g Text 3 2
24 g Text 5 4

I am trying to create a formula that takes a name from a list of individual names and checks the above table to see if a row contains both the name in column a and a specified text in column b. If both values are present in the row I want the formula to return the value in column c.

I want to use the formula to populate the table below:

  E F G H
1 Name Text 1 Text 2 Text 4
2 a      
3 b      
4 c      
5 d      
6 e      
7 f      
8 g      

So, the formula in F2 should use the name from E2 which is “a”. It should then find instances of “a” in A2:A24, and if B2:B24 also has “Text 1” in the same row the formula should return the value from column C in the same row. If the formula is possible it should return the value 12 in cell F2.

I would then use the an adjusted version of this formula to check for names

I would really appreciate someone’s help with this. It’s probably simple, but I just cannot crack it despite a lot of searching online!!


By: Rob Sadler

15 thoughts on “Compare two values in an array and if they match in a row, return a value from the third column in the same row.

  1. ig

    Hello to all, how is everything, I think every one is getting more from this website, and your views are good in support
    of new people.

  2. Les

    I know this site offers quality dependent content and additional stuff, is there any other
    site which gives such things in quality?

  3. Shae Wiscombe

    I genuinely enjoy reading through on this site, it has excellent posts. “The living is a species of the dead and not a very attractive one.” by Friedrich Wilhelm Nietzsche.

  4. sling tv

    With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My blog
    has a lot of completely unique content I’ve either written myself or outsourced but it seems a lot of it is popping it up all over
    the web without my agreement. Do you know any ways to help reduce
    content from being stolen? I’d truly appreciate it.

  5. sling tv

    Hi are using WordPress for your blog platform? I’m new to the blog world but I’m trying to get started and
    set up my own. Do you require any html coding knowledge to make your own blog?
    Any help would be really appreciated!

  6. coconut oil

    I love your blog.. very nice colors & theme.
    Did you design this website yourself or did you hire someone to do it for
    you? Plz reply as I’m looking to design my own blog and would like to find out where u got this from.

    appreciate it

  7. quest bars cheap

    What i do not understood is actually how you’re no longer really a lot more well-appreciated than you may be now.
    You are so intelligent. You already know thus significantly
    when it comes to this topic, made me individually consider it from numerous numerous angles.
    Its like men and women aren’t involved except
    it’s one thing to accomplish with Girl gaga! Your personal stuffs outstanding.
    Always handle it up!

  8. ps4 games

    It’s really a cool and helpful piece of info. I’m glad that you
    just shared this useful information with us. Please keep us informed like this.
    Thank you for sharing.

  9. ps4 games

    Hello! Do you know if they make any plugins to assist with SEO?
    I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very
    good success. If you know of any please share. Many thanks!

  10. ps4 games

    When someone writes an paragraph he/she maintains the plan of a
    user in his/her brain that how a user can be aware of it.
    Thus that’s why this post is outstdanding. Thanks!

Comments are closed.