Multiple lookups

adidani

New member
Joined
Jan 12, 2017
Messages
8
Reaction score
0
Points
0
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 a moderator:
LetterValue
A2
B4
C5
A8
C6

Q2Advanced
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:
 
attached file - last tab vlookup sumif

see file attached
 

Attachments

  • Junior Analyst Candidate Test Dec 2016.xlsx
    53.1 KB · Views: 12
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)
 
Back
Top