Join databases with VLOOKUP
A common requirement in Excel is to join databases with VLOOKUP. This often happens when there is a common item in the databases. Examples of this are when you want to show product codes and names or
show a client number and client name if they are on different lists.