Calculate RAND function only once

Hi,

I have a workbook that calculates a RAND function based on input in another cell. Specifically, the formula in E2 selects a random text string from another range depending on data entered in D2. I want to be able to fill this formula down for use multiple times.

The formula works fine on its own, but the problem comes when I, say, move on to D3 to input more data. E3 does its random calculation as it should, but E2 also recalculates; I want E2 to remain static once it calculates the first time.

I am not familiar with VBA, but it looks like the solution may have to come from there. Can anyone help me with this?

I'm attaching the workbook in question. The calculation I'm referring to is in the 3rd worksheet.

Thanks!

TLL Injury Machine.xlsx

Thanks so much - this does the trick exactly. I'm still learning!