Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Fuzzy match-output/match columns not loading

Copper Contributor

I added Fuzzy Match to excel, but the match/output columns won't load.  Is there something I need to do under configure?  It works, but brings in all columns from both sheets.

3 Replies

@J-Ash 

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

adversi_0-1605627880139.png

3. Control what columns are returned in the Output Columns and the threshold below

Actually, it just started working.  I don't know why it wouldn't load before.  Thank you!

 

 

 

 

@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.