How to Join Vlookup in Excel?

In Excel, you can use the "&" operator to join the results of two or more VLOOKUP formulas together. Here's how you can do it:

  1. Start by writing your first VLOOKUP formula in the cell where you want to display the combined result. For example, if you want to look up a customer's name based on their ID number, you might write a VLOOKUP formula in cell A1 like this: =VLOOKUP(ID, Table1, 2, FALSE)
  2. Next, write your second VLOOKUP formula in the next cell over. For example, if you want to look up the customer's city based on their ID number, you might write a VLOOKUP formula in cell B1 like this: =VLOOKUP(ID, Table2, 2, FALSE)
  3. To join the results of the two VLOOKUP formulas together, simply use the "&" operator between them. For example, in cell C1, you could write a formula like this: =VLOOKUP(ID, Table1, 2, FALSE) & " - " & VLOOKUP(ID, Table2, 2, FALSE)
  4. When you press Enter, the formula in cell C1 will combine the results of the two VLOOKUP formulas with a hyphen in between. For example, if the first formula returns "John Smith" and the second formula returns "New York", the formula in cell C1 will display "John Smith - New York".

Note that you can use as many VLOOKUP formulas as you need to join together in this way, and you can add additional text or characters between the results as needed by enclosing them in quotes within the formula.