Forum Discussion
Excel Matching
I have a list of Museum Numbers and Catalogue Numbers. (1000s) On a separate excel I have a shorter list of museum numbers. Is there a quick way for me to automatically match the shorter list wi...
If both workbooks are open it is possible to use XLOOKUP between master and slave workbooks.
(even if the file names are mixed up - sorry)