Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
index/match type issue
I am creating an order page that has Columns A (Department), B (Part Number),
C (Quantity), and D (Need By Date). The Worksheet name is "Order". What I'm trying to do is retrieve the information in Column B and do an Index/Match type function on Worksheet "Cut List". The cut list page has a list of 1922 parts that our Laser cuts. The part number in row B on the Order page needs to search Column E on the Cut List page. Once the part numbers are matched I would like Column A's value in "Order" to be the new value in Column A on the "Cut List" page and so on. I need this process to continue on until all parts on the "Order" page have been accounted for. I'm looking in the books I have for something similar that I can adjust but I'm only finding how to copy ranges from one worksheet to the other. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A vlookup/index-match type problem | Excel Discussion (Misc queries) | |||
IF AND MATCH data type issue | Excel Worksheet Functions | |||
MATCH & INDEX ISSUE? | Excel Discussion (Misc queries) | |||
index match issue | Excel Worksheet Functions |