Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data pick-up
I have information exported from an accounting system into an Excel
spreadsheet. The export has 3 columns; the first column contains the value of the first data of the range; the second column contains the end value of the range; the third column shows a percentage rate applicable to all values within the range. e.g. C00123 C00125 15% C00128 C00130 100% Note there is a gap between the end value at column 2 in row 1 and the next value in column 1 of row 2. The intervening range has a default percentage rate of 0%. If I have a separate list of just data such as: C00123 C00124 C00125 C00126 C00127 C00128 C00129 C00130 C00131 is it possible to allocate the data in column 3 of the original export to this list by a formula? i.e. I could use a formula copied down in the next column that would refer to the original export, and pick up the 3rd column data, including the data not shown therein (i.e. the 0% allocated to the "invisible" ranges between the ranges shown) to arrive at: C00123 15% C00124 15% C00125 15% C00126 0% C00127 0% C00128 100% C00129 100% C00130 100% C00131 0% et seq Thank you for any help you can offer. -- Geoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pick data from an array | Excel Discussion (Misc queries) | |||
Extract data value using pick list | Excel Worksheet Functions | |||
How to pick data from different sheets conditionally? | Excel Worksheet Functions | |||
Getting charts to automatically pick data from a series | Charts and Charting in Excel | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions |