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.
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.
I'll need to study both responses. I have no docs except the Excel help file (MS Office 365). I'll see if I understand the proposals and then get back to you both. Thanks for your assistance.
Eric
