LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use Check Box input in a cell's fomula? WentBlank Excel Worksheet Functions 1 June 29th 07 01:22 AM
Trying to select a specific range based on the time value of user form input Jitranijam New Users to Excel 8 November 15th 06 12:52 AM
how to extract input data? jackoat Excel Worksheet Functions 0 March 28th 06 06:45 AM
How to extract input data? jackoat Excel Discussion (Misc queries) 0 March 28th 06 06:40 AM
Select cell from range based on input in excel xp dingy101 Excel Discussion (Misc queries) 3 November 20th 05 12:05 AM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"