I'll try to explain what I need.......
I plan a production line. Each product has a set of routers (stages) that need to happen in order to make it, eg dispensary, filling, packaging, micro testing and then shipping.
I have all the products to be made in a month on an excel sheet, in a column (all the part numbers). I will then have all part numbers with their respective router list in another file. I need to have some sort of look up which gives me (on another sheet) the part number on the plan and then the list of routers underneath it, and then the next part number on the plan with it's routers and so on. I can only do basic VLOOKUPS which look for one reference and then report back what is in another column in the same row. How do you say "look for this part number and tell me what is in the (for eg) 8 rows beneath it ?
thanks
Paula
I plan a production line. Each product has a set of routers (stages) that need to happen in order to make it, eg dispensary, filling, packaging, micro testing and then shipping.
I have all the products to be made in a month on an excel sheet, in a column (all the part numbers). I will then have all part numbers with their respective router list in another file. I need to have some sort of look up which gives me (on another sheet) the part number on the plan and then the list of routers underneath it, and then the next part number on the plan with it's routers and so on. I can only do basic VLOOKUPS which look for one reference and then report back what is in another column in the same row. How do you say "look for this part number and tell me what is in the (for eg) 8 rows beneath it ?
thanks
Paula