Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy in order
In Sheet1 - I have a crew list in joining order, for example
Bunk Name 101 name-a 108 name-b 103 name-d 105 name-f In sheet2 €“ I have a bunk list in bunk order 101 102 103 104 105 106 107 Is there any formula to look up sheet1 and copy the corresponding names and place in sheet2 corresponding columns, for example like this? 101 name-a 102 blank 103 name-d 104 blank 105 name-f Please help me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cells down a column (in order) to across a row (same order?? | Excel Discussion (Misc queries) | |||
How to copy excel to text in a certain order. | Excel Discussion (Misc queries) | |||
copy columns with order reversed | Excel Discussion (Misc queries) | |||
copy the order number to corresponding cells | Excel Discussion (Misc queries) | |||
Copy cells in a determined order | Excel Discussion (Misc queries) |