Microsoft Office Forums - View Single Post - [Solved] Copying data related to one item to worksheet with many instances of the same item

Thread: [Solved] Copying data related to one item to worksheet with many instances of the same item

View Single Post

Old

02-04-2016, 08:54 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

I think a Vlookup is what you need.

=IFERROR(VLOOKUP(A1,Sheet2!A1:J200,2,FALSE),"None found")

This will return the value in the second column next to the word in Sheet2 that matches the word in A1 of Sheet1. If none is found, a message is displayed.

Reply With Quote