I have a worksheet (Sheet 1) with computer names on it - each on a row that has an empty cell to list an asset tag.
I have a second worksheet (Sheet 2) that contains exported info from a much larger DB of historical computer names, which includes their asset tags.
I'd like to search "Sheet 2" for the machine names listed in Sheet 1 --> and automatically update the empty asset tag on Sheet 1 with the respective asset tag.
Bookmarks