Multiple Lookup help please

[dontbugme1]

Im trying to come up with a formula that will fill in missing fields on 2 criteria
please bear with me while i try to explain.

Data

datetime------------EndTime------------- Station--Fruit
24/02/2016 09:13 24/02/2016 09:13 206 Apple
24/02/2016 09:09 24/02/2016 09:14 213
24/02/2016 09:08 24/02/2016 09:12 217 Pear

4 Columns that sometimes having missing Data in Fruit Column
looking up another table complete the missing Fruit.
by looking up what fruit is at that station between those dates from a second table.

datetime----------- Station----Fruit
24/02/2016 09:13 217 Orange
24/02/2016 09:09 217 Pear
24/02/2016 09:13 212 Grape

formula in D4 lookup C4 in column F and also Column E is between Column A & B
samp.gif

[jewelsharma]

try this array formula in cell D4 and autofill:

Please Login or Register  to view this content.

Note: Array Formula must be entered/confirmed with [Ctrl] + [Shift] + [Enter]