how to do this ?? beside vlookup?

apple · Apr 10th, 2002, 10:10 PM

i use vlookup to find the materials which matched the width and thickness i entered. as the width and thickness appeared a few in the lookup table and there many different type of material for the same width and thickness. so how can i find the specified material for the width and thickness i entered. thanx for ur reply

Brian from Maui · Apr 11th, 2002, 12:26 AM

Quote:

On 2002-04-10 21:10, apple wrote:
i use vlookup to find the materials which matched the width and thickness i entered. as the width and thickness appeared a few in the lookup table and there many different type of material for the same width and thickness. so how can i find the specified material for the width and thickness i entered. thanx for ur reply

What is the criteria for selecting the material, if there are many materials for the same width and thickness

apple · Apr 11th, 2002, 12:36 AM

the criteria selecting the material is dat when the width and thickness enter by the user match the width*thickness in the table, it will take the material with the specify width and thickness but there are many material which match the width and thickness.
by using Vlookup, i can only get i type of material with the width and thickness enter. i wan to be able to choose the material.
thanx for e help.

Brian from Maui · Apr 11th, 2002, 12:52 AM

Quote:

On 2002-04-10 23:36, apple wrote:
the criteria selecting the material is dat when the width and thickness enter by the user match the width*thickness in the table, it will take the material with the specify width and thickness but there are many material which match the width and thickness.
by using Vlookup, i can only get i type of material with the width and thickness enter. i wan to be able to choose the material.
thanx for e help.

Try using the IF function or post some data you have and criteria for selecting a material. I'm sure someone here will help

apple · Apr 11th, 2002, 01:12 AM

below r a rough pix of how the data is like. i don't think if function can help as if function can check 7 x but my data have 300 fields. thanx Brian.

WIDTH 042.0MM(user input)
Thickness 0.20MM(user input)

RAW MATERIAL (check from the table shown below with the specify width and thickness)

0.180MM * 06.000MM BECU C17200 ALLOY 290 TM06 (MILL HARDEN)
0.180MM * 28.580MM CRS 1010 T 3 TEMPER
0.180MM * 45.720MM CRS 1010 T 3 TEMPER
0.20MM * 007.00MM BECU ALLOY 290 TM06
0.20MM * 014.0MM PHOSPHOR BRONZE SPRING TEMPER C52100
0.20MM * 015.0MM BERYLLIUM COPPER ALLOY 25 C1720 ( ½ HARD )
0.20MM * 017.00MM PHOSPHROUS BRONZE 1 / 2 HARD
0.20MM * 020.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 020.0MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED)
0.20MM * 022.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 022.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 023.80MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED)
0.20MM * 023.80MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED)
0.20MM * 024.0MM BERYLLIUM COPPER ALLOY 25 1/4 HARD
0.20MM * 026.0MM NICKEL SILVER CDA 770 1/2 HARD
0.20MM * 026.0MM NICKEL SILVER CDA 770 1/2 HARD
0.20MM * 027.0MM PHOSPHROUS BRONZE 1 / 2 HARD
0.20MM * 027.94MM NICKEL SILVER CDA #770 1/2 HARD
0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 032.0MM NICKEL SILVER (1/4 HARD)
0.20MM * 032.0MM NICKEL SILVER (1/4 HARD)
0.20MM * 034.00MM PHOSPHORUS BRONZE 1/2 HARD
0.20MM * 034.0MM PHOSHOR BRONZE
0.20MM * 034.0MM PHOSHOR BRONZE 1/2 HARD
0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 038.0MM NICKEL SILVER CDA 770 1/4 HARD
0.20MM * 040.0MM NICKEL SILVER CDA 770 1/4 HARD
0.20MM * 040.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 040.0MM COLD ROLLED STEEL C1008/1010
0.20MM * 040.0MM NICKEL SILVER (1/4 HARD)
0.20MM * 040.0MM NICKEL SILVER (1/4 HARD)
0.20MM * 040.0MM NICKEL SILVER CDA 770 (1/4 HARD)
0.20MM * 040.0MM STAMPING PART (#30053A) STICK WITH HARD RUBBER (#30060-1)
0.20MM * 042.00MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 042MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 042.0MM NICKEL SILVER CDA 770 1/4 HARD
0.20MM * 042.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 042.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 043.0MM PHOSPHOR BRONZE C5191R-H / C5210R-H
0.20MM * 044.450MM NICKEL SILVER CDA 770 1/4 HARD
0.20MM * 045.00MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 048.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 048.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 048.0MM NICKEL SILVER CDA 770 1/4 HARD
0.20MM * 048.0MM SUS 301 1/4 HARD
0.20MM * 048MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 053.0MM ETP COPPER C1100 (PRE-PLATED)
0.20MM * 055.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK
0.20MM * 060.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 061.00MM NICKEL SILVER ( ¼ HARD)
0.20MM * 061.0MM NICKEL SILVER (1/4 HARD)
0.20MM * 061.0MM NICKEL SILVER CDA770 (1/4 HARD)
0.20MM * 062.0MM ETP COPPER C1100 (PRE-PLATED)
0.20MM * 068.00MM NICKEL SILVER CDA 770
0.20MM * 068.0MM NICKEL SILVER CDA 770
0.20MM * 068.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD
0.20MM * 120.00MM SUS 301 1/2HARD
0.20MM / 007.00MM BECU ALLOY 290 TM06
0.250MM * 0.320MM PHOSPHOR BRONZE CDA510 (PRE-PLATED)
0.250MM * 0.320MM PHOSPHOR BRONZE CDA510 (PRE-PLATED)
0.250MM * 0.4150MM CRS 1010 PRE-PLATED WITH NICKEL AND BRIGHT TIN
0.250MM * 13.50MM BERYLLIUM COPPER ALLOY 25 1/4HARD

Brian from Maui · Apr 11th, 2002, 01:19 AM

Apple,

I don't think I have the Excel knowledge to help, but I'm sure someone will. Why are there duplicates or triplicates for the same width, thickness, and material? Is it the price?

apple · Apr 11th, 2002, 01:30 AM

Oh. there r duplicat data becoz the same width and thickness give different material for different use. they are not the price.

Brian from Maui · Apr 11th, 2002, 01:41 AM

Apple,

I apologize, I don't have the knowledge on this one. Just be patient someone will come along and solve this in due time. I didn't heed Jack's warning, "don't bite off more than you can chew". Although the what you "use" certainly will be a criteria to help search for the right product.

eliW · Apr 11th, 2002, 02:22 AM

The best way in my oppinion to treat your problem is to use Filter AutoFilter from your menu, or Advanced Filter. This way you'll get the desired records.
Eli

Ian Mac · Apr 11th, 2002, 03:19 AM

Hi,

could you answer a few questions please,

1) why ARE there duplicate entries, I know it's already been answered but from your sample:

0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN
0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN

are all the same, do you need select from these or return any of them, if the former, how do you tell the difference?

2) What are your field headings, I can't really tell what it what, is it just three?

3) what is the 0.20MM * 020.0MM, is this 2 different fields?

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-04-11 02:19 ]

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

Apr 10th, 2002, 10:10 PM	#1
apple New Member Join Date: Mar 2002 Location: web Posts: 8	i use vlookup to find the materials which matched the width and thickness i entered. as the width and thickness appeared a few in the lookup table and there many different type of material for the same width and thickness. so how can i find the specified material for the width and thickness i entered. thanx for ur reply

Apr 11th, 2002, 12:36 AM	#3
apple New Member Join Date: Mar 2002 Location: web Posts: 8	the criteria selecting the material is dat when the width and thickness enter by the user match the width*thickness in the table, it will take the material with the specify width and thickness but there are many material which match the width and thickness. by using Vlookup, i can only get i type of material with the width and thickness enter. i wan to be able to choose the material. thanx for e help.

Apr 11th, 2002, 01:12 AM	#5
apple New Member Join Date: Mar 2002 Location: web Posts: 8	below r a rough pix of how the data is like. i don't think if function can help as if function can check 7 x but my data have 300 fields. thanx Brian. WIDTH 042.0MM(user input) Thickness 0.20MM(user input) RAW MATERIAL (check from the table shown below with the specify width and thickness) 0.180MM * 06.000MM BECU C17200 ALLOY 290 TM06 (MILL HARDEN) 0.180MM * 28.580MM CRS 1010 T 3 TEMPER 0.180MM * 45.720MM CRS 1010 T 3 TEMPER 0.20MM * 007.00MM BECU ALLOY 290 TM06 0.20MM * 014.0MM PHOSPHOR BRONZE SPRING TEMPER C52100 0.20MM * 015.0MM BERYLLIUM COPPER ALLOY 25 C1720 ( ½ HARD ) 0.20MM * 017.00MM PHOSPHROUS BRONZE 1 / 2 HARD 0.20MM * 020.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 020.0MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED) 0.20MM * 022.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 022.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 023.80MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED) 0.20MM * 023.80MM PHOSPHOR BRONZE CDA510 1/2 HARD (PRE-PLATED) 0.20MM * 024.0MM BERYLLIUM COPPER ALLOY 25 1/4 HARD 0.20MM * 026.0MM NICKEL SILVER CDA 770 1/2 HARD 0.20MM * 026.0MM NICKEL SILVER CDA 770 1/2 HARD 0.20MM * 027.0MM PHOSPHROUS BRONZE 1 / 2 HARD 0.20MM * 027.94MM NICKEL SILVER CDA #770 1/2 HARD 0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 028.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 028.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 032.0MM NICKEL SILVER (1/4 HARD) 0.20MM * 032.0MM NICKEL SILVER (1/4 HARD) 0.20MM * 034.00MM PHOSPHORUS BRONZE 1/2 HARD 0.20MM * 034.0MM PHOSHOR BRONZE 0.20MM * 034.0MM PHOSHOR BRONZE 1/2 HARD 0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 035.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 038.0MM NICKEL SILVER CDA 770 1/4 HARD 0.20MM * 040.0MM NICKEL SILVER CDA 770 1/4 HARD 0.20MM * 040.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 040.0MM COLD ROLLED STEEL C1008/1010 0.20MM * 040.0MM NICKEL SILVER (1/4 HARD) 0.20MM * 040.0MM NICKEL SILVER (1/4 HARD) 0.20MM * 040.0MM NICKEL SILVER CDA 770 (1/4 HARD) 0.20MM * 040.0MM STAMPING PART (#30053A) STICK WITH HARD RUBBER (#30060-1) 0.20MM * 042.00MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 042.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 042MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 042.0MM NICKEL SILVER CDA 770 1/4 HARD 0.20MM * 042.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 042.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 043.0MM PHOSPHOR BRONZE C5191R-H / C5210R-H 0.20MM * 044.450MM NICKEL SILVER CDA 770 1/4 HARD 0.20MM * 045.00MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 048.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 048.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 048.0MM NICKEL SILVER CDA 770 1/4 HARD 0.20MM * 048.0MM SUS 301 1/4 HARD 0.20MM * 048MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 053.0MM ETP COPPER C1100 (PRE-PLATED) 0.20MM * 055.0MM COLD ROLLED STEEL C1010-1008 (PRE-PLATED MATTE FINISHED) 0.0060" THICK 0.20MM * 060.00MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 061.00MM NICKEL SILVER ( ¼ HARD) 0.20MM * 061.0MM NICKEL SILVER (1/4 HARD) 0.20MM * 061.0MM NICKEL SILVER CDA770 (1/4 HARD) 0.20MM * 062.0MM ETP COPPER C1100 (PRE-PLATED) 0.20MM * 068.00MM NICKEL SILVER CDA 770 0.20MM * 068.0MM NICKEL SILVER CDA 770 0.20MM * 068.0MM NICKEL SILVER CDA 770 ALLOY 1/4HARD 0.20MM * 120.00MM SUS 301 1/2HARD 0.20MM / 007.00MM BECU ALLOY 290 TM06 0.250MM * 0.320MM PHOSPHOR BRONZE CDA510 (PRE-PLATED) 0.250MM * 0.320MM PHOSPHOR BRONZE CDA510 (PRE-PLATED) 0.250MM * 0.4150MM CRS 1010 PRE-PLATED WITH NICKEL AND BRIGHT TIN 0.250MM * 13.50MM BERYLLIUM COPPER ALLOY 25 1/4HARD

Apr 11th, 2002, 01:19 AM	#6
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Apple, I don't think I have the Excel knowledge to help, but I'm sure someone will. Why are there duplicates or triplicates for the same width, thickness, and material? Is it the price?

Apr 11th, 2002, 01:30 AM	#7
apple New Member Join Date: Mar 2002 Location: web Posts: 8	Oh. there r duplicat data becoz the same width and thickness give different material for different use. they are not the price.

Apr 11th, 2002, 01:41 AM	#8
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Apple, I apologize, I don't have the knowledge on this one. Just be patient someone will come along and solve this in due time. I didn't heed Jack's warning, "don't bite off more than you can chew". Although the what you "use" certainly will be a criteria to help search for the right product.

Apr 11th, 2002, 02:22 AM	#9
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	The best way in my oppinion to treat your problem is to use Filter AutoFilter from your menu, or Advanced Filter. This way you'll get the desired records. Eli

Apr 11th, 2002, 03:19 AM	#10
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Hi, could you answer a few questions please, 1) why ARE there duplicate entries, I know it's already been answered but from your sample: 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN 0.20MM * 020.0MM CRS 1010 PRE-PLATED WITH HOT DIPPED BRIGHT TIN are all the same, do you need select from these or return any of them, if the former, how do you tell the difference? 2) What are your field headings, I can't really tell what it what, is it just three? 3) what is the 0.20MM * 020.0MM, is this 2 different fields? _________________ Share the wealth!! Ian Mac [ This Message was edited by: Ian Mac on 2002-04-11 02:19 ]