chr1ssy
New Member
- Joined
- Mar 24, 2022
- Messages
- 1
- Office Version
- 365
- 2010
- Platform
- Windows
I am pulling in a table using Power Query into spreadsheet1. I have added a few columns using vlookups to other tables. Is there a way I could create a running list on another tab that captures all #N/A fields from the vlookup columns in the table? Ideally this list is live and grows and shrinks based on the amount of errors there are. It could point to another column in the table for a point of reference for me to see which fields to update and fix. Thanks!