Hi All,
I have a list of names Cell P18-P37
I wanted to fill a color if my list of names in Cell C3-C68 matches my list in Cell P18-P37
I can't seem to make it work using index match
Any Help would be highly appreciated
Hi All,
I have a list of names Cell P18-P37
I wanted to fill a color if my list of names in Cell C3-C68 matches my list in Cell P18-P37
I can't seem to make it work using index match
Any Help would be highly appreciated
How about
=MATCH(C3,P$18:P$37,0)
Works like a charm
Thanks mate
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks