how to do this ?? beside vlookup?

[apple]

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

 

[Aladin Akyurek]

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.

 

[apple]

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

 

[apple]

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.

 

[Aladin Akyurek]

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.