Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: how to do this ?? beside vlookup?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    web
    Posts
    8
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    web
    Posts
    8
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    web
    Posts
    8
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    web
    Posts
    8
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  8. #8
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  9. #9
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •