Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Multiple lookups

  1. #1

    Multiple lookups



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    If I have a table with 2 columns: one with letters and the second with corresponding values aside the letters how do I return the first value of c and the second value of the same letter. meaning there are 2 "C"'s on the first column and each time the function/formula should return only one value for each "c".
    vLOOKUP works for the first "c" (because the function returns the value for the first "c"), though not so sure it's the ideal solution....

    I'd be glad to get advice here.

    Thanks in advance
    AdiChnage
    Last edited by Pecoflyer; 2017-01-13 at 07:53 AM. Reason: Change title

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by adidani View Post
    I'd be glad to get advice here.
    Please, attach your example file with expected results
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Letter Value
    A 2
    B 4
    C 5
    A 8
    C 6

    Q2 Advanced
    Using ONLY SUMIF and/0r VLOOKUP (alone or in a combination)
    Return the first value of C
    Answer: 5
    Return the second value of C
    Answer:

  4. #4

    attached file - last tab vlookup sumif

    see file attached
    Attached Files Attached Files

  5. #5

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,673
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Is this some kind of homework?
    Thank you Ken for this secure forum.

  7. #7

    not homework

    Quote Originally Posted by Pecoflyer View Post
    Is this some kind of homework?
    not at all - any idea how to do it?

  8. #8

  9. #9
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by adidani View Post
    Using ONLY SUMIF and/0r VLOOKUP (alone or in a combination)
    In cell E20 try (exclusively for this task)
    Code:
    =SUMIF(A7:A11;"C";B7:B11)-VLOOKUP("c";A7:B11;2;0)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  10. #10
    cool, thanks a lot

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •