I have one tab that has about 1000 uniquely identified items by name. Then on the second tab I have about 2000 items uniquely identified by name and serial number. I want to take one tabs information, match the items on tab two then return the serial number to a cell next to the matching item on tab one. See example below:
Tab 1
Serial # Item Name
Desk
Keyboard
Monitor
Mouse
Tab 2
Serial # Item Name
159263 Desk, Small
134570 Desk
321146 Keyboad, Wireless
449321 Keyboard
157943 Monitor
321648 Monitor, 15
166624 Monitor, 17
13476 Monitor, 19
445568 Monitor, 20
156461 Monitor, 22
321648 Mouse
I am open to an if formula, match, vlookup, etc. I am hoping someone else has already been there and done that, and will share.
Thank you,
DW
Bookmarks