Lookup a value Closed

Question

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

Game Start Now · Answer

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.

Ray · Answer

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.

Ray · Answer

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

Lookup a value

3 responses

Similar discussions

Subscribe To Our Newsletter!