LookUp values from two columns and calculate accordingly

[Dineth]

Hello,

I would be very grateful if somebody could kindly look in to my problem.

Here is the story, I have to make a dummy progress data file, instead of just creating random data I would prefer to generate some smart data.

We are (non profit) an agricultural firm, our field officers (located in 5 districts) are giving farmers some planting materials (3 crop types) to cultivate (for free, but it doesn't matter)

I need to make a dummy progress data and I need to generate random-between values where min and max values based on district and crop.

a sample data file is attached. any help will be highly appreciated. Thank you.

[newdoverman]

Taking a guess here. I added two columns to the main table on Sheet1...Min and Max and in the progress subtracted the Min from the Max for each row. I then created a Pivot Table.
There is no real indication of how you are gathering your statistics so this is my best guess at the moment.

[Dineth]

Taking a guess here. I added two columns to the main table on Sheet1...Min and Max and in the progress subtracted the Min from the Max for each row.

Thanks for your time. what I need to generate is random data between min and max values for respected district and crop accordingly. This is a dummy data to create and demonstrate a dash board. Not measuring Progress by Min and Max values. It's just to create more practical values (based on our real field expected values) rather than just creating a random data for each district and crop uniformly.

Sorry for any inconvenience because of my poor writing skills to express my need more accurately. English is not my first language.

[newdoverman]

To generate values between the min and max values you could use RANDBETWEEN.
=RANDBETWEEN(MIN VALUE, MAX VALUE)
To fill in the main table with values between the MIN and MAX values in the smaller table. This will do that. Enter in H2 with Ctrl + Shift + Enter. This is an ARRAY FORMULA.

Please Login or Register  to view this content.

[Dineth]

fantastic. No words to express my thankfulness.

[newdoverman]

Glad to help. Thanks for the feedback.