Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match values in column against another column and move
I have one worksheet with columns A - H holding data for month of May that
represents lost goods. In columns I - P I have data for the month of May as well showing me what we found goods. These Columns are broken up by LOST GOODS A - DATE B - PRODUCT C - SERIAL NUMBER D - H (OTHER INFORMATION ON PRODUCT) FOUND GOODS I - DATE J - PRODUCT K - SERIAL NUMBER L - P (OTHER INFORMATION ON PRODUCT) What I want to do is match up the PRODUCT in column B with the product in column J. on the same row. However it moves it's I - P when doing so. Any ideas or suggestions would be great! Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move a row of data values to a column in sorted order | Excel Discussion (Misc queries) | |||
Match values in more than one column | Excel Worksheet Functions | |||
match values in two column and return value in | Excel Worksheet Functions | |||
MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN | Excel Worksheet Functions | |||
Move column values w/o formula | Excel Worksheet Functions |