'Getting row number of approximate VLOOKUP match
I have two large lists which I would like to compare. I want to know which cells have stayed the exact same and which cells have been modified slightly but are an "approximate" match. I am currently using a VLOOKUP to check if the cells are exactly the same and using a match function to check which row the counterpart is in. However, for the approximate match I want to know the same thing but I have not been able to find an answer. Therefore, my questions is it possible to get the row number of approximate VLOOKUP match and if not, is there another way of doing it without the use of VBA?
Column B: =IF(IFERROR(VLOOKUP([@[Rev 1]],F2:$F$4,1,FALSE),"")<>"","Same","Change")
Column C: =IF(IFERROR(VLOOKUP([@[Rev 1]],F2:$F$4,1,TRUE),"")<>"",IF([@[Exact Match]]="Same","Same","Approx. the same"),"Change")
Column D: =IFERROR(MATCH([@[Rev 1]],$F$2:$F$4,0),"")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|