Everything Zach said. It is much easier to select the column for return value rather than count the columns from an array in VLOOKUP.People who love INDEX MATCH over VLOOKUP, please explain when/how it is useful. I am having a helluva time working it into my excel routine.
If columns D, E, F are my data source and I want to return email addresses to a list of unique identifiers, this is the syntax.
And yes, it still works across sheets/books. It was just easier for me to demonstrate in one sheet.