Search a customer id from one mulisheets

**itsnag8** · 03-13-2012, 07:49 PM

Hello All,

I am working on excel work, where in I need search for customer id in one worksheet on mulitiple worksheets of the excel spread sheet and I should keep all the matched records from different sheets into new sheet.

For example: for the customer id in 'DTO' - 05410654003180111, I should look in ATO,BTO,CTO and should update the 'FINAL' sheet as shown below.

DTO ATO BTO CTO
05410654003180111 RS 5410654003180111 A N J 00000000000000000 P N 5410654003180111 085 5410654003180111 A N 5410654003180111 5410654003180111 N P P P 085

Note:
1.Customer id is key in all sheets
2. Customer Id in 'DTO' sheet alone will have an extra zero towards the left.

I am attaching the same sheet below.
Any macro or tool on this would help me alot in my work. Looking forward for your help. thanks in advance!

**rylo** · 03-13-2012, 09:26 PM

Hi

Where does the RS come from in Final!B2?

rylo

**itsnag8** · 03-13-2012, 11:51 PM

HI Rylo,

RS is the 2 column value corresponds to customer id in the DTO tab. Thanks!

itsnag

**DGagnon** · 03-14-2012, 12:13 AM

you can use a series of vlookups like this, i think this is yoru desired output

**rylo** · 03-14-2012, 05:37 PM

HI

In the example file it is AF not RS. Do you want all the items from DTO as the starting point in Final, or are you looking for all possible unique customer IDs across all the data sheets with the relevant matches when they appear?

rylo

**itsnag8** · 03-14-2012, 11:20 PM

Hi Rylo, you are correct, that is AF.
I would like to have info for all customers I'ds in DTO sheet, in my actual sheet I have thousands of customer I'ds , if it is macro kind of stuff, it is easy for me to validate the entries. Thanks in advance!