vlookup with date range

[orsm6]

Hi everyone.

I've tried a number of examples to get this thing working but I have looked at so many versions I've confused myself, hoping you can help.

Cell holding the formula: E6

I need to look up cell B6 (this will copied down the column, so next row is B7 etc etc)
Look up B6 in range 'SAP Dump'!$B$2:$M$31
value to return is in column index 8 ('SAP Dump'!$I$I)


here is the annoying bit I need to return the value it finds only the look up value is between a date range.
The date range cells are need to be between $E$3 and $E$4
There is a column of dates on the SAP Dump sheet in column L

Any help would be awesome, thanks.

 

[Special-K99]

Some of this is not clear.

"I need to return the value it finds only the look up value is between a date range."

You've specified the lookup value is B6
You've also specified the date range is in E3 and E4

So this is just

=IF(AND(B6>=$E$3,B6<=$E$4),VLOOKUP(B6,'SAP Dump'!$B$2:$M$31,8,0),"")

So that's all you need.
Why are you mentioning dates in column L ? These dates are superfluous based on the rest of your description.

 

[orsm6]

It does sound strange now that I read it back lol... I'll have a go at this Monday morning and see how I go.

This formula looks like something that will do what I needed lol, I need to do some more study on formulas I think

Thank you for replying.