Combining two formulas For Using the Random Formula If A Cell is Blank

jsonb8men

New Member
Joined
Aug 18, 2021
Messages
1
Platform
  1. MacOS
  2. Web
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!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,320
Messages
6,171,432
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top