Vlookup only returns one column that matches the value searched. I
wanted to return several columns, otherwise, I am forced to use
vlookup for each column.

Below is an example

Customer ID, Customer Name, Address1, Address2, City, State, Zip


If I match on Customer ID, then I want name, address, city, state zip
in one shot.

Is this possible?