how to do this ?? beside vlookup? - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: how to do this ?? beside vlookup?

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,827
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 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
    Try to repost your data. The best way to do it is as follows:

    Go to the worksheet that houses your lookup (materials). Activate an empty cell, type =, select 10 rows of your table (including labels/column headings), hit F9, copy what you see after the =-sign, and paste what you copied in the follow up (or paste it over the contents of your earlier post by using the Edit option.

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

    Default

    Hi, Ian

    i know dat Qns is ans but never mind i will include the heading separate by / . the 0.002MM * 56.0MM is actually the specification of the material. the are in the same column
    i know i can include field like UR(usage) or Job together with the width and specification when lookup but what if the job is a new job? i will not find the materials. i have try many method like macro dialog box, form list box using index(), Vlookup and etc...

    Can anybody help????????????



    BL JOB / UR /SPECIFICATIONTHICKNESS*WIDTH) / MATERIAL
    20914-3 / 0.1750 / BRASS CDA #260 HARD
    30308 / 0.238 / 0.002MM * 56.0MM / SUS 301 1/2HARD
    20825 / 0.454 / 0.0035MM * 1.310MM / NI AG CDA770 SPRING TEMPER
    20831 / 0.363 / 0.0035MM * 1.310MM / NI AG CDA770 SPRING TEMPER
    20820 / 0.454 / 0.0035MM * 1.310MM / NI AG CDA770 SPRING TEMPER
    12376B / 0.509 / 0.003MM * 1.1250MM / 300 SERIES SST FULL HARD



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

    Default

    hi, Aladin Akyurek
    i try ur method(Go to the worksheet that houses your lookup (materials). Activate an empty cell, type =, select 10 rows of your table (including labels/column headings), hit F9, copy what you see after the =-sign, and paste what you copied in the follow up (or paste it over the contents of your earlier post by using the Edit option) but as my data fields is too huge it will work. i know it work with same data. so how?? i can't exclude other data as the are together for checking.



  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,827
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-11 20:48, apple wrote:
    hi, Aladin Akyurek
    i try ur method(Go to the worksheet that houses your lookup (materials). Activate an empty cell, type =, select 10 rows of your table (including labels/column headings), hit F9, copy what you see after the =-sign, and paste what you copied in the follow up (or paste it over the contents of your earlier post by using the Edit option) but as my data fields is too huge it will work. i know it work with same data. so how?? i can't exclude other data as the are together for checking.
    Just post that portion that is relevant.

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
  •  

 

DMCA.com