Hello,
I'm trying to figure out a way to use Vlookup to bring back multiple values for specific terms. Here is a sample of what my reference table looks like:
Col. A Col. B
Magi1 15
Magi1 9
Magi1 12
Magi1 13
Hspx9 4
Hspx9 2
Rrbm16 23
Rrbm16 31
Rrbm16 17
So I I'm trying to find the values in Column A, for example Magi1, and then use my formula to return each value corresponding to Magi1, which here would be 15, 9, 12, and 13. I don't want to sum these Column B values or anything. I just want to see all the Column B values that each correspond to a specific value in Column A.
Thank-you
Bookmarks