How To Populate Date Conditinally?

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
500
Office Version
  1. 2010
Platform
  1. Windows
Dear All,
I do have the following sample data set across A1:F4.

SiteSKUQtyDateMaximum QtyMaximum Qty Date
a11001-Oct3510-10-2019
a13510-Oct3510-10-2019
a12524-Oct3510-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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,287
Office Version
  1. 365
Platform
  1. Windows
How about
=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
Joined
Jul 2, 2009
Messages
500
Office Version
  1. 2010
Platform
  1. Windows
How about
=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
Joined
Jun 12, 2014
Messages
48,287
Office Version
  1. 365
Platform
  1. Windows
My pleasure & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,167
Members
410,775
Latest member
alal1030
Top