office 2010 - Excel multi column lookup -

I am unsure of how this is Google. I have a table that looks like the bottom

  last name | First name Team A | Team B | Team C Smith | John | X | | Do | | Jane | | X |  

This will be the main sheet, the names of this sheet are divided into other sheets, depending on which department they are involved in. Those sheets are setup in the same format with the same column. If people in the main sheet are marked in one of the columns, then I should mark that same column marked with department sheets.

Your best bet might be to create a hidden column A where the value is all your tabs But there is a combination of column B and column C. You can then use standard VLOOKUP wrapped in the IFERROR section.

For example,

  = IFERROR (VLOOKUP (A1, Sheet1! A: F, 3, False), "")  

IFERROR handles this example that there may be a name on your sub-tab on the main tab, it gives empty space in place of #N / ​​A, what value is being examined in A1 on your main tab in VLOOKUP A1 is. A1 will be the combination of the first and the last VLUKUP in each of your columns, changing the number instead of the columns in each VLUUP.