Not sure if this is the right section lol.
So I need help with this sheet:
*i.imgur.com/PDw67hn.png
Notice that the values of A6 and C1 are identical.
What is going on here?
A1 to A3 have a Data Validation Form
A23 to I34 have the data
A5 to A10 is a list of items matching the required criteria, that is available.
B5 to B8 are 3 random items picked from A5 to A10, which will be served.
Notice that the formula in A6 is identical to the contents of C1. This has been manually entered in A6, but generated based on data validation forms in C1. In C1, it changes if different items are picked from the data validation form. Need to make it automatic in A6, based on the contents of C1. This is the point of the thread.
What are the formulas used?
A6
B6
C1
B1
What has already been tried?
=INDIRECT("B2")
and
=INDIRECT(B2)
both do not work.
=CELL(Contents, "C1")
and
=CELL(Contents, C1)
also both do not work
What do I really want to do?
I want a randomised subset of available items to be presented every day. It might be for an alt history RPG game in an imaginary restaurant.
PS, sorry, but the food items are also imaginary.
PPS, there is no political commentary here.
PPPS, this is also not about veg and non veg.
Anyone who wants to look at the sheet it can do so here.
NPCs will die of hunger, PLS HALP
So I need help with this sheet:
*i.imgur.com/PDw67hn.png
Notice that the values of A6 and C1 are identical.
What is going on here?
A1 to A3 have a Data Validation Form
A23 to I34 have the data
A5 to A10 is a list of items matching the required criteria, that is available.
B5 to B8 are 3 random items picked from A5 to A10, which will be served.
Notice that the formula in A6 is identical to the contents of C1. This has been manually entered in A6, but generated based on data validation forms in C1. In C1, it changes if different items are picked from the data validation form. Need to make it automatic in A6, based on the contents of C1. This is the point of the thread.
What are the formulas used?
A6
=FILTER(A25:A34, I25:I34="y", D2534 ="y", B25:B34 ="y")
B6
=ArrayFormula(Array_Constrain(vlookup(Query({ROW(A6:A10),randbetween(row(A6:A10)^0,9^9)},"Select Col1 order by Col2 Asc"),{row(A6:A10),A6:A10},2,FALSE),3,1))
C1
="=FILTER(A24:A34, "&B1&" ="&char(34)&"y"&char(34)&", "&B2&" ="&char(34)&"y"&char(34)&", "&B3&" ="&char(34)&"y"&char(34)&")"
B1
=HLOOKUP(A1,F23:I34, 2, FALSE)
What has already been tried?
=INDIRECT("B2")
and
=INDIRECT(B2)
both do not work.
=CELL(Contents, "C1")
and
=CELL(Contents, C1)
also both do not work
What do I really want to do?
I want a randomised subset of available items to be presented every day. It might be for an alt history RPG game in an imaginary restaurant.
PS, sorry, but the food items are also imaginary.
PPS, there is no political commentary here.
PPPS, this is also not about veg and non veg.
Anyone who wants to look at the sheet it can do so here.
NPCs will die of hunger, PLS HALP