Not sure if using a formula is the right approach here....if so, which one?

[Elmo1239]

Hello all,

I have a sheet filled with various quotes that I enjoy/relate to and like to see occasionally as a reminder. Let's call this sheet "Quotes". Each quote is in an individual cell.

I have another sheet that could be considered a "Menu" page from where I can select the other pages I would like to see/work on.

My end goal is to figure out a way to populate a single cell on the "Menu" page with a quote from the "Quotes" sheet, but that would select & display a new quote on a daily basis.

Is there a formula that would select one quote amongst a whole range of values and display it on another sheet?

Thanks for any suggestions/help you have!

 

[etaf]

how about using a column with numbers in
and a lookup
=INDEX(B2:B27,MATCH(RANDBETWEEN(1,26),A2:A27,1))

Randbetween ( the range of numbers )

Book1
	A	B	C	D
1	No.	Quote		A B C 19
2	1	A B C 1
3	2	A B C 2
4	3	A B C 3
5	4	A B C 4
6	5	A B C 5
7	6	A B C 6
8	7	A B C 7
9	8	A B C 8
10	9	A B C 9
11	10	A B C 10
12	11	A B C 11
13	12	A B C 12
14	13	A B C 13
15	14	A B C 14
16	15	A B C 15
17	16	A B C 16
18	17	A B C 17
19	18	A B C 18
20	19	A B C 19
21	20	A B C 20
22	21	A B C 21
23	22	A B C 22
24	23	A B C 23
25	24	A B C 24
26	25	A B C 25
27	26	A B C 26
Quote

Cell Formulas
Range	Formula
D1	D1	=INDEX(B2:B27,MATCH(RANDBETWEEN(1,26),A2:A27,1))

 

[Fluff]

Or without a helper column.
Although it's volatile so will change whenever any cell changes or recalculates.

+Fluff 1.xlsm
	A	B	C
1	Quote		A B C 20
2	A B C 1
3	A B C 2
4	A B C 3
5	A B C 4
6	A B C 5
7	A B C 6
8	A B C 7
9	A B C 8
10	A B C 9
11	A B C 10
12	A B C 11
13	A B C 12
14	A B C 13
15	A B C 14
16	A B C 15
17	A B C 16
18	A B C 17
19	A B C 18
20	A B C 19
21	A B C 20
22	A B C 21
23	A B C 22
24	A B C 23
25	A B C 24
26	A B C 25
27	A B C 26
28
Master

Cell Formulas
Range	Formula
C1	C1	=INDEX(A2:A27,RANDBETWEEN(1,ROWS(A2:A27)))

 

[Elmo1239]

how about using a column with numbers in
and a lookup
=INDEX(B2:B27,MATCH(RANDBETWEEN(1,26),A2:A27,1))

Randbetween ( the range of numbers )

Book1
	A	B	C	D
1	No.	Quote		A B C 19
2	1	A B C 1
3	2	A B C 2
4	3	A B C 3
5	4	A B C 4
6	5	A B C 5
7	6	A B C 6
8	7	A B C 7
9	8	A B C 8
10	9	A B C 9
11	10	A B C 10
12	11	A B C 11
13	12	A B C 12
14	13	A B C 13
15	14	A B C 14
16	15	A B C 15
17	16	A B C 16
18	17	A B C 17
19	18	A B C 18
20	19	A B C 19
21	20	A B C 20
22	21	A B C 21
23	22	A B C 22
24	23	A B C 23
25	24	A B C 24
26	25	A B C 25
27	26	A B C 26
Quote

Cell Formulas
Range	Formula
D1	D1	=INDEX(B2:B27,MATCH(RANDBETWEEN(1,26),A2:A27,1))

Awesome, this worked perfectly, thanks Etaf!

 

[Elmo1239]

Or without a helper column.
Although it's volatile so will change whenever any cell changes or recalculates.

+Fluff 1.xlsm
	A	B	C
1	Quote		A B C 20
2	A B C 1
3	A B C 2
4	A B C 3
5	A B C 4
6	A B C 5
7	A B C 6
8	A B C 7
9	A B C 8
10	A B C 9
11	A B C 10
12	A B C 11
13	A B C 12
14	A B C 13
15	A B C 14
16	A B C 15
17	A B C 16
18	A B C 17
19	A B C 18
20	A B C 19
21	A B C 20
22	A B C 21
23	A B C 22
24	A B C 23
25	A B C 24
26	A B C 25
27	A B C 26
28
Master

Cell Formulas
Range	Formula
C1	C1	=INDEX(A2:A27,RANDBETWEEN(1,ROWS(A2:A27)))

Great, thanks for the added input! Appreciate everyone's help with this one!

 

[Fluff]

Glad we could help & thanks for the feedback.