The formula: VLOOKUP(lookup value, table array, column number, [range lookup]) Lookup Value: The identical value you have in both spreadsheets. Choose the first value in your first spreadsheet. In Sprung's example that follows, this means the first email address on the list, or cell 2 (C2). Table Array: The range of columns on Sheet 2 you're going to pull your data from, including the column of data identical to your lookup value (in our example, email addresses) in Sheet 1 as well as the column of data you're trying to copy to Sheet.
In our example, this is "Sheet2!A:B." "A" means Column A in Sheet 2, which is the column in Sheet 2 where the data identical to our lookup value (email) in Sheet 1 is listed. The "B" means Column B, which contains the information that's only fax number list available in Sheet 2 that you want to translate to Sheet 1. Column Number: The table array tells Excel where (which column) the new data you want to copy to Sheet 1 is located. In our example, this would be the "House" column, the second one in our table array, making it column number 2. Range Lookup: Use FALSE to ensure you pull in only exact value matches. The formula with variables from Sprung's example below.
VLOOKUP(C2,Sheet2!A:B,2,FALSE) In this example, Sheet 1 and Sheet 2 contain lists describing different information about the same people, and the common thread between the two is their email addresses. Let's say we want to combine both datasets so that all the house information from Sheet 2 translates over to Sheet 1. Here's how that would work: Excel formulas and shortcuts: VLOOKUP 15. RANDOMIZE There's a great article that likens Excel's RANDOMIZE formula to shuffling a deck of cards. The entire deck is a column, and each card 52 in a deck is a row. "To shuffle the deck," writes Steve.