extract data from a range based on other cell's input
 

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

extract data from a range based on other cell's input
 

It sounds like you need a lookup formula. See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Snooky" wrote in message
...
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