Comparing Columns and Populating With Description

I am looking to build a macro that will compare a column from the master sheet against the same column in multiple sheets then if the rows match up, I'd like to pull the description on the other sheets back into the master sheet.

I've attached a sample excel file. In the file, you can see I'm trying to pull the description from the other sheets into the master sheet by finding the table name and searching the column name.

Hi

Master Sheet!C2: =IFERROR(VLOOKUP(B2,INDIRECT(A2&"!a:b"),2,FALSE),"") Copy down as required.

HTH

rylo

Worked perfectly, thanks!

Can you walk me through the logic for how it knows to grab the description? I'd like to know how it works in the event I want to use the same formula to say pull in another field like comments based on the same criterias. Thanks!

Hi

It is using the standard VLOOKUP function to find the item, and then move across to the second column and return the value found there.
ISERROR is used so that if it doesn't find an item, it will show a blank rather than an error result
INDIRECT is used to determine the name of the sheet that you are using, as well as the range, for the VLOOKUP. This really only worked as you have the department name available, and you have named the sheets with the same name.

Make sense?

rylo