Nov 17 2020 07:14 AM
Nov 17 2020 07:45 AM
The image is not displaying the entire options, but here is a checklist of what's needed:
1. Make sure both datasets are converted to tables
2. A link exists under Matched Columns for the lookup, you would need to click on the column names and then click on the center button
3. Control what columns are returned in the Output Columns and the threshold below
Dec 12 2023 11:48 AM
@J-Ash I added a column to the second table. Fuzzy Lookup wasn't recognizing the new column. I closed and re-opened the file and the new column was there. I think Excel cache has something to do with why new columns aren't recognized unless you close the file and re-open.