vLookUp return several columns?
General Fear wrote:
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?
=VLookup(lookup_value, lookup_array, {2,3,4,5,6,7}) array entered.
Alan Beban
|