# How To Populate Date Conditinally?

#### xlmaniac

##### Well-known Member
Dear All,
I do have the following sample data set across A1:F4.

 Site SKU Qty Date Maximum Qty Maximum Qty Date a 1 10 01-Oct 35 10-10-2019 a 1 35 10-Oct 35 10-10-2019 a 1 25 24-Oct 35 10-10-2019

<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>

In column E the formulae is as follows:-
E2=MAX(IF(\$A\$2:\$A\$4=A2,IF(\$B\$2:\$B\$4=B2,\$C\$2:\$C\$4)))

I am looking for formulae across Column F which can yield the desired result as given above.
Pls help.
Thanks

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### Fluff

##### MrExcel MVP, Moderator
=INDEX(\$D\$2:\$D\$4,MATCH(A2&"|"&B2&"|"&E2,INDEX(\$A\$2:\$A\$4&"|"&\$B\$2:\$B\$4&"|"&\$C\$2:\$C\$4,0),0))

#### xlmaniac

##### Well-known Member
=INDEX(\$D\$2:\$D\$4,MATCH(A2&"|"&B2&"|"&E2,INDEX(\$A\$2:\$A\$4&"|"&\$B\$2:\$B\$4&"|"&\$C\$2:\$C\$4,0),0))

Thanks a lot Fluff for helping me out again with your mesmerising solution!!
Really appreciate the same!!
My sincere gratitude to you!!

#### Fluff

##### MrExcel MVP, Moderator
My pleasure & thanks for the feedback

Replies
3
Views
49
Replies
6
Views
102
Replies
1
Views
70
Replies
3
Views
119
Replies
2
Views
148