Return value from adjacent cell next to min date in that row

[Prattlesnake]

Hello, I'm having trouble even figuring out how to search for an answer to this.


For a row, I want to return the contents of a cell who's adjacent cell contains the earliest date in that row.


I am looking in a row, say row 6 from C to K.


L is where I'd put this formula.


Cells E, G, I and K have dates, cells D, F, H, and J have types of fruit.


What I want to do is return in cell L the Fruit from cell D, F, H, or J who's adjacent date cell (E, G, I, K) is the EARLIEST of the four dates in that row.


My mind is going towards Index, Match, and Min, but I'm not completely sure on that.


Any thoughts would be great!


Thanks


-Prattlesnake


Link to file (skydrive) http://sdrv.ms/100wprz

 

[Hui]

Prattlesnake


Firstly, Welcome to the Chandoo.org Forums


L6: =OFFSET(C6,,MATCH(MIN(E6,G6,I6,K6),E6:K6,0))

Copy down

 

[Prattlesnake]

Oh my science, Hui, that is splendid.


Thank you much, exactly what I needed.


Thank's for the welcome, as well.


-P