Search results

The number has to be user entered, I wish to set the limit as per the data in other cell as Q, R

I need to assign three sets of number for a cell, depending on the data entry at another location in the sheet. For Eg- if the data entry in cell A4 is Q, the number range in C10 should lie between 1-10, say for data entry at A4 as R, the number range should lie between 10 and 100 and so on...