Siimple Match/Index/Vlookup (not sure which one?) formula...

[mlarson]

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!

 

[mlarson]

Glad that worked and then assuming that the main formula is now working as you expect as well?

Yes, it is. Thank you! Problem solved!

 

[mlarson]

For the sake of my general knowledge, how would the original formula be altered to allow approximate match instead of exact match? Thanks.

 

[philwojo]

You could try this:

[COLOR=#333333]=IFERROR(INDEX($P$8:$Q$13,MATCH("*"&C8&"*",$Q$8:$Q$13,0),1),"")[/COLOR]

Or in your case for the trailing space you could do this:

[COLOR=#333333]=IFERROR(INDEX($P$8:$Q$13,MATCH(C8&"*",$Q$8:$Q$13,0),1),"")[/COLOR]

 

[mlarson]

philwojo, you're a stud! Thank you, works very well!

 

[philwojo]

Glad to help, but just passing along things I've learned on here from those much much smarter than I am.