Return cell values as date

[aligahk06]

Dear All,


I want a formula in excel for following problems.
I want to match values available in colH 001,014,015,GH1 and return a random date in between date (eg 7/7/2018,14/7/2018,21/07/2018,29/07/2018) in a cell column if match value found else nothing.


Any Assistance.

Rgds,
aligahk06

 

[Oscar Cronquist]

Can you provide the desired outcome?

 

[aligahk06]

Can you provide the desired outcome?

Desired outcome either 7/7/2018 or 14/07/2018 or 21/07/2018 or 29/07/2018

 

[Oscar Cronquist]

Try this:

	A​	B​	C​	D​
1​	001	14/7/2018		001
2​	002			014
3​	003			015
4​	004			GH1
5​	GH1	29/07/2018
6​	006
7​	007
8​	008
9​	009
10​	010
11​	011
12​	GH1	21/07/2018
13​	013
14​	014	21/07/2018
15​	015	14/7/2018

Sheet: Sheet25

Formula in cell B1:
=IF(OR(INDEX(A1=$D$1:$D$4,)),INDEX({"7/7/2018","14/7/2018","21/07/2018","29/07/2018"},RANDBETWEEN(1,4)),"")