Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vLookUp return several columns?
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup return value from 2 columns | New Users to Excel | |||
VLookup: Return Multiple Columns? | Excel Discussion (Misc queries) | |||
vlookup to return 2 columns | Excel Discussion (Misc queries) | |||
vlookup 3 columns all return same | Excel Discussion (Misc queries) | |||
Can I return multiple columns from a vlookup? | Excel Worksheet Functions |