Previous Topic Next Topic

Lookup a value

Closed
Ray - Aug 26, 2010 at 05:31 PM
 Ray - Aug 27, 2010 at 01:06 PM
Hello all,

In Excel, I'd like to be able to return a value from sheet2:c1 into sheet1:B1 where a date in sheet1:A1 is between a date in sheet2:A1 and a date in sheet2:C1.
e.g.
Sheet1
A1 B1
8/15/2010 8
9/10/2010 9

Sheet2
A1 B1 C1
8/2/2010 8/25/2010 8
8/26/2010 9/20/2010 9

Is this possible without resorting to VBA?
thanks
Ray

3 replies

Answer 1 / 3
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
 7
Aug 27, 2010 at 03:39 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.
0
Answer 2 / 3
Ray
Aug 27, 2010 at 12:58 PM
The file would look just like my example. Two sheets, one with a date the other with a date range that the date from sheet1 would be in.
Need to return the value from sheet2 from the range that it matches.
0
Answer 3 / 3
Ray
Aug 27, 2010 at 01:06 PM
Sheet1
A B
1 8/15/2010 8
2 9/10/2010 9

Sheet2
A B C
1 8/2/2010 8/25/2010 8
2 8/26/2010 9/20/2010 9
0