Trouble with excel columns match

Closed
DP - Apr 20, 2010 at 09:40 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 20, 2010 at 09:43 AM
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.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 20, 2010 at 09:43 AM
How you have used VLOOKUP. Can you share your vlookup formula
0