Formula to pick dates

[Muthukrishnan V]

Excel 2007.
Columns A, B and C : contains dates in dd/mm/yyyy format.

Column D : contains number in single digit (1 in some cells, 2 in some cells; 3 in some cells) (Col D only single digit number either 1 or 2 or 3).


Example of one row:


A1 : 25-04-2018; B1: 27-04-2018; C1: 29-04-2018. D1: 1

Requirement:
Column E1 should pick the date.

If D1: 1, then pick date 25-04-2018 as in A1.

If D1: 2, then pick date 27-04-2018 as in B1.

If D1: 3, then pick date 29-04-2018 as in C1.

Request formula.

 

[Rick Rothstein]

I think you may be looking for this...

=CHOOSE(D1,A1,B1,C1)

 

[jtakw]

Hi,

This will do it:

Excel 2010
	A	B	C	D	E
1	4/25/2018	4/27/2018	4/29/2018	2	4/27/2018
Sheet7

Cell Formulas
Range	Formula
E1	=CHOOSE(D1,A1,B1,C1)