how to do this ?? beside vlookup?

apple

New Member
Joined
Mar 26, 2002
Messages
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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
Oh. there r duplicat data becoz the same width and thickness give different material for different use. they are not the price.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,317
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top