Trouble with excel columns match

Closed
DP - 20 Apr 2010 à 09:40
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Apr 2010 à 09:43
Here is my problem, I have a defined set of numbers in one column. I have another column with variable numbers, some of which may match numbers from Column #1. I am trying to search column #2 to see if any of the numbers match. If they do match I would like to highlight them green, or at least mark them as "Yes" or "Good". Can someone help? I have tried a variety of formulas including VLOOKUP and MATCH, but they are not working how I would like them to. Thank you.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Apr 2010 à 09:43
How you have used VLOOKUP. Can you share your vlookup formula