Quizzes & Puzzles6 mins ago
Datamatch 2 Excel Spreadsheets
0 Answers
Hi,
I have two excel spread sheets that I need to data match, the large (master) version is approx. 60000 lines and the second is weekly report with approx. 200 lines, I need to match against name, date of birth and order date. I have been using a VLOOKUP, not all cases on the weekly report are on the master, is there a better way to do this ?
I have two excel spread sheets that I need to data match, the large (master) version is approx. 60000 lines and the second is weekly report with approx. 200 lines, I need to match against name, date of birth and order date. I have been using a VLOOKUP, not all cases on the weekly report are on the master, is there a better way to do this ?
Answers
Best Answer
Nobody has yet answered this question. Once some answers have been given, andyGTBristol will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There are no answers available for this question.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.