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.
=INDEX($A$3:$A$24,MATCH(F3,$B$3:$B$24,0))An alternative could be INDEX and MATCH. VBA isn't required if i correctly understand you want to do. Of course you can adapt the formula according to the actual size of the data e.g.
=INDEX($A$3:$A$57000,MATCH(F3,$B$3:$B$57000,0))