How to use vlookup in excel 2019 different sheets

WeвЂ™ll expand this example further by adding a column to table B for surnames, making it link the birthday dates to actual people. In this case, for ID number 123, VLOOKUP returns a birthdate of (using the DD/MM/YY format). It returns data from column number 4 in this range (column D, вЂњBirthdayвЂќ), and, as we want an exact match, the final argument is FALSE.

To break this down, VLOOKUP uses the F4 cell value (123) as the search key and searches the range of cells from A3 to D9. The appropriate VLOOKUP formula for this is =VLOOKUP(F4, A3:D9, 4, FALSE). In this example, weвЂ™ll use VLOOKUP to provide the birthday for a specific employee ID number. In a second table, you can use VLOOKUP to search for data that uses any of the criteria from the first table (name, ID number, or birthday). The first table is a list of employeesвЂ™ names, ID numbers, and birthdays. Using VLOOKUP on a Single SheetДЇor this example, letвЂ™s say you have two tables with data on a single sheet. In most cases, you either have to disregard the data in columns to the left of your search key or place your search key data in the first column. One thing to note is VLOOKUP canвЂ™t search through data to the left of the column index number. You can use the ID number as your VLOOKUP search value to find the price for each product quickly. A company spreadsheet might have two sheets: one with a list of products (each with an ID number and price), and a second with a list of orders. HereвЂ™s an example of how you might use VLOOKUP. If youвЂ™d rather return exact matches to your search key, you set this argument to FALSE. The final argument is only important if youвЂ™re looking for the closest match to your search key value.

How to use vlookup in excel 2019 different sheets