3 Easy Ways To Find Matching Values In Two Columns In Excel

If the two columns are not side by side, simply hold down Ctrl and select whichever columns you need.

The other box in the pop-up window allows you to change the colors Excel uses to indicate duplicates. The default is “Light Red Fill with Dark Red Text”, but you may choose whichever you prefer.

The other box in the pop-up window allows you to change the colors Excel uses to indicate duplicates. The default is “Light Red Fill with Dark Red Text”, but you may choose whichever you prefer.

Using conditional formatting to find matching values is a handy way to find matches that may not be in the same row.

The “17” in the formula indicates 17 rows of data. Change the number to fit however many rows of data you have. The “FALSE” value at the end of the formula is what tells Excel to look for an exact match in value. Replace it with “TRUE” to search for the nearest match that is less than or equal to the corresponding data point (represented in this case by B1). [2] X Research source Just entering “=VLOOKUP” in Excel will pull up the full formula, which you can reference in populating each field with the necessary info.

The “17” in the formula indicates 17 rows of data. Change the number to fit however many rows of data you have. The “FALSE” value at the end of the formula is what tells Excel to look for an exact match in value. Replace it with “TRUE” to search for the nearest match that is less than or equal to the corresponding data point (represented in this case by B1). [2] X Research source Just entering “=VLOOKUP” in Excel will pull up the full formula, which you can reference in populating each field with the necessary info.