I have a columns of customer id numbers, names, addresses, state zip, how can I get my client to pick the id number and it returns the data of the name address etcc in the next cell, i used vlookup but it only returns the data in one column, are there many ways to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - pick id and merge row data into one cell
- Thread starter dkriese
- Start date
From the use of vlookup, I presume you are using excel
To get other data, you need to use vlookup but change the 3rd argument eg.
If data is et out Cust ID in col A, name in B, address in C, zip in D, then, on your sheet where you want to get the data, enter the customer ID into A2,
To get name, in B2, enter:
=vlookup($A2,sheet1!$A$2:$D$1000,2,false)
where your data goes to row 1000 - change as appropriate
For address, in C2:
=vlookup($A2,sheet1!$A$2:$D$1000,3,false)
and for zip, in D2:
=vlookup($A2,sheet1!$A$2:$D$1000,4,false)
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
To get other data, you need to use vlookup but change the 3rd argument eg.
If data is et out Cust ID in col A, name in B, address in C, zip in D, then, on your sheet where you want to get the data, enter the customer ID into A2,
To get name, in B2, enter:
=vlookup($A2,sheet1!$A$2:$D$1000,2,false)
where your data goes to row 1000 - change as appropriate
For address, in C2:
=vlookup($A2,sheet1!$A$2:$D$1000,3,false)
and for zip, in D2:
=vlookup($A2,sheet1!$A$2:$D$1000,4,false)
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
- Status
Similar threads
- Locked
- Question
- Locked
- Question