have trouble matching

Aborigen · May 16th, 2002, 04:22 AM

Hello Excel gurus!!!

I would appreciate if someone could help me with my problem.
I have 2 worksheets,on the 1st worksheet which displays all possible kit combinations I have 3 columns:
KIT_ID,part# and Desc.
Many parts can belong to one game kit.

On the second worksheet I only have a KIT_ID
column with 20 kits which change every week.

I want to show what part#'s & description are associated with those 20 kits.

I have tried running a VLookup but it stops after finding the first match.

Thanks in advance

zzydhf · May 16th, 2002, 05:46 AM

I have the same problem. this may be the totally wrong way to do it but....
I sort by kit # then part number on the sheet with the kits with multiple #s. In a new column(b) I put a counter (the following would be in b2)- if(a2=a1,b1+1,1). then in c2 - =a2&" - "&b2. This gives you a kit number with a -1, -2, -3 suffix.

On the main page I basically create multiple duplicate records for each kit # and put the same counter and -1, -2, -3 to match on.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 04:22 AM	#1
Aborigen New Member Join Date: May 2002 Posts: 1	Hello Excel gurus!!! I would appreciate if someone could help me with my problem. I have 2 worksheets,on the 1st worksheet which displays all possible kit combinations I have 3 columns: KIT_ID,part# and Desc. Many parts can belong to one game kit. On the second worksheet I only have a KIT_ID column with 20 kits which change every week. I want to show what part#'s & description are associated with those 20 kits. I have tried running a VLookup but it stops after finding the first match. Thanks in advance

May 16th, 2002, 05:46 AM	#2
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	I have the same problem. this may be the totally wrong way to do it but.... I sort by kit # then part number on the sheet with the kits with multiple #s. In a new column(b) I put a counter (the following would be in b2)- if(a2=a1,b1+1,1). then in c2 - =a2&" - "&b2. This gives you a kit number with a -1, -2, -3 suffix. On the main page I basically create multiple duplicate records for each kit # and put the same counter and -1, -2, -3 to match on.