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