| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to bring value from another sheet with different spaces
i have 2 sheets in a workbook. I want Sheet 1 column A to bring in the value
from sheet 2 column D. The problem is the data on Sheet 2 in column D has 3 spaces between each sku and on sheet 1 column A the spaces between each item to be 4 so i for example i want a formula in Sheet 1 in row1 than in row6 picking up the item from sheet 2 from row D3 and than D6 and so on. Sheet1 Sheet2 1 1009655 2 3 1009655 4 5 6 1009685 1009685 7 8 9 1008654 10 11 1008654 thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bring information from one sheet to another | Excel Worksheet Functions | |||
| formula needed to bring values to another sheet | Excel Worksheet Functions | |||
| Bring one sheet from one workbook to another via formula | Excel Discussion (Misc queries) | |||
| how to bring an image onto a sheet | Excel Worksheet Functions | |||
| How bring a color on cell from one sheet to another | Excel Discussion (Misc queries) | |||
Threaded Mode
