Note: having problems making the data look like an Excel chart... hopefully it's clearer than mud 
Thanks in advance for your help! I'm not sure if this is a match, index, vlookup? But I'm guessing it's pretty simple to do.
I'm looking for a formula that will do the following:
Match the text in cells in Column C with the text in cells in Column Q. When there's a match, take the value in Column P that is in the same row of the matched Column Q cell, and copy/paste that Column P value in Column B of the same row as the matched Column C cell. Column B can be left blank if there's no match.
Column B is output
B C P Q
71 green 72 white
88 blue 65 violet
34 yellow 71 green
(blank) orange 88 blue
72 white 92 pink
(blank) black 34 yellow
Thank you!

Thanks in advance for your help! I'm not sure if this is a match, index, vlookup? But I'm guessing it's pretty simple to do.
I'm looking for a formula that will do the following:
Match the text in cells in Column C with the text in cells in Column Q. When there's a match, take the value in Column P that is in the same row of the matched Column Q cell, and copy/paste that Column P value in Column B of the same row as the matched Column C cell. Column B can be left blank if there's no match.
Column B is output
B C P Q
71 green 72 white
88 blue 65 violet
34 yellow 71 green
(blank) orange 88 blue
72 white 92 pink
(blank) black 34 yellow
Thank you!
Last edited: