I have an Excel sheet with data formatted as below
A B
1 KEY VALUE
2 Apple Golden
3 Orange Navel
4 Banana Yellow
5 Apple Gray Smith
6 Orange Blood
What I want to do is take the unique keys, but print their corresponding values horizontally next to them. I already have a sheet that looks like this:
A B
1 KEY VALUE
2 Apple Golden
3 Orange Navel
4 Banana Yellow
But what I would like is this:
A B C
1 KEY VALUE1 VALUE2
2 Apple Golden Gray Smith
3 Orange Navel Blood
4 Banana Yellow
My formula right now is {=INDEX('$B$2:$B$6,MATCH(<unique key>,$A$2:$A$6,0))} where "unique key" is the cell reference in the second sheet. This formula successfully prints the first value for each key, but I would like for the other matches to populate down the row. Is that possible?
- - , .
برچسب:
نویسنده: استخدام کار