Vlookup Returning Values based on Date Range

**kgibson20** · 01-10-2011, 03:52 PM

I have a spreadsheet where I need to return a value of 1 if the number on one spreadsheet matches a number on another spreadsheet and the date next to it falls into the range I've specified at the top of the first sheet if not it will return a 0.I've attached a file that simplifies it into one sheet. I need to return a 1 in column D if the matching number from column E has a date next to it within the range specified at the top. I was using a vlookup which works fine, but I would like to be able to change the data (1,0) based on the date range. The formula I'm using is VLOOKUP(D4,$E$4:$F$15,2,FALSE). Any help would be appreciated

**ChemistB** · 01-10-2011, 03:57 PM

Are we matching C and E or E and F?

**NBVC** · 01-10-2011, 03:59 PM

Try:

=--(AND(VLOOKUP(C4,$E$4:$G$15,3,0)>=$B$1,VLOOKUP(C4,$E$4:$G$15,3,0)<=$B$2))

**kgibson20** · 01-10-2011, 04:05 PM

That did the trick. Thank you very much.

**honest1122** · 06-28-2012, 09:12 AM

Hi,
Thought to revive the this thread since my problem is similar.
Attaching the sheet as I want to return the data. Please refer to the attachment as it has all required details.
"Needs the value appearing in column G, if the value in A5 is (less than F5, then return G5), if its equal or more than F5 but less than F6, then return G6), if its equal or more than F6 but less than F7, then return G7 ) and so on……."