1. ## Multiple lookups

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....

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. ## attached file - last tab vlookup sumif

see file attached

5. attached

6. Is this some kind of homework?

7. ## not homework

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

8. attached

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)`

10. cool, thanks a lot

Page 1 of 2 1 2 Last

#### Posting Permissions

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