Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey there,
Not the best at wording but here it goes... I have a 2-column 12-row range of data. One column is a description, the other is a value of currency. I have another range on the same sheet with one column for each day of the month and multiple rows. In each column, based on day, I want to input a description which is exactly the same as the description in the 2-col/12-row range. I want excel to look at the description, find the currency value based on the other range and input that value in the same column as the description, just lower in rows. Also, I want to be able to have a second description in row 2 (the next one down from the first) and have it do the same with a sum function to add all the currency values on the bottom. I could have to use up to 10-12 rows. Can this be done? Really really appreciate the help on this one! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use Check Box input in a cell's fomula? | Excel Worksheet Functions | |||
Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
how to extract input data? | Excel Worksheet Functions | |||
How to extract input data? | Excel Discussion (Misc queries) | |||
Select cell from range based on input in excel xp | Excel Discussion (Misc queries) |