View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Snooky Snooky is offline
external usenet poster
 
Posts: 1
Default 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