I am currently using google sheets for an automation project that works with another application. So the application feeds the formula in cell H7 < =ArrayFormula(Array_Constrain(vlookup(Query({ROW(A4:A9),randbetween(row(A4:A9)^0,9^9)},"Select Col1 order by Col2 Asc"),{row(A4:A9),A4:A9},2,FALSE),1,1)) > which picks up a random output from a4 to a9 for our use. Now, i am introducing another input from the application that fills out the i2 with a text. So the formula that im looking for is to add to the existing array formula in H7- that If the cell i2 is blank then use the random function to pick it from a4:a9 or else show the i2 instead.
I hope this makes sense. Any assistance would be appreciated.
Thanks!
I hope this makes sense. Any assistance would be appreciated.
Thanks!