Thread: Exact Match
View Single Post
 
Old 03-21-2019, 02:21 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
There are several ways to compare 2 columns, and which one to use greatly depends on what you want to get (what is returned).

From your last post I got a vague impression, VLOOKUP() is what will do for you. Look in attached workbook.
Attached Files
File Type: xlsx MatchExample.xlsx (8.3 KB, 10 views)
Reply With Quote