Using LOOKUP or MATCH

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I'm trying to use the value of a cell (say X3) to look on
a second tab in the same workbook and list all the
matches back on the first tab starting in cell Y3. The
cells I'm trying to match are a number (14 (which is
weeks)) and then get all the part numbers that have 14
weeks. Sometimes there are multiple part numbers with the
same amount of weeks, I can use LOOKUP and get the first
occurance but then gettin the second, third, fourth... is
where I'm having trouble. Can this be done? Can it also
be put into a text box? (Optional).

Thank you for all the help and being there to provide
expertise and guidance.

Joe
 
I think I blew it when describing what I wanted to do,
sorry.
Say I have the following information:

Column A B C (want these results)
Part Delivery Longest Delivery
123 14 123
456 10 789
789 14 223
123 8
321 9
223 14
123 stk

What I'm trying to accomplish is have a formula enter all
the parts with 14 and list them starting in row C (it
should look like C above). I have tried =LOOKUP(LEFT(TRIM
(H4),2),'Priced BOM Summary Page'!S3:S82,'Priced BOM'!
D3:D82) and =MATCH(LEFT(TRIM(H4),2),'Priced BOM'!
S3:S82,0) but have errors. Can this be done.

TIA
Joe
 
Back
Top