Everything Zach said. It is much easier to select the column for return value rather than count the columns from an array in VLOOKUP. 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.