Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Snooky - 18 May 2008 19:21 GMT
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
T. Valko - 18 May 2008 22:06 GMT
It sounds like you need a lookup formula. See if this helps:

http://contextures.com/xlFunctions02.html

Signature

Biff
Microsoft Excel MVP

> Hey there,
> Not the best at wording but here it goes...
[quoted text clipped - 19 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.