I have two spreadsheets. Both spreadsheets have Material listed in Column A.
Spreadsheet 2 has a value in Column H that needs to be carried over to
Column H of Spreadsheet 1. The Material list in Spreadsheet 2 is only a
partial listing of the Material in Spreadsheet 1. How do I ask Excel to
enter a corresponding value in Spreadsheet 1 if the Material appears on
Spreadsheet 2? I inherited these spreadsheets and the first time I manually
entered the values€¦there has got to be a better way since Spreadsheet 2 has
280+ entries to be dropped among the 5000+ entries on Spreadsheet 1.