Forum Discussion
Solved
Help please. Is a simple Excel macro the way to go?
I need to explain the situation. The is a dog application. I have two files. One is 57,000 records and the other is 500 records. The larger file has been reduced to a record ID and the name of the do...
Why not do the following:
- Create a VLOOKUP or XLOOKUP formula to retrieve the record IDs.
- Select the range with the formulas, copy it, then paste as values.
Well, I was working my way through the various LOOKUP functions and discovered that my large data file, the source for the looked up data, is corrupted. Many of the dog names have invalid or incorrect IDs. So, rather than allow the errors to continue, I'll just wait until the migration to the new system is complete and figure out how to proceed at that time. Meanwhile I've found documentation of the XLOOKUP function so I'll study this and be prepared to start at a later date. Thanks for setting me on the correct path even if we didn't accomplish the task at hand.