Data Validation and Multi Section Question

[tiosonsoner]

Hello,

If cell C17 contains "1040", the maximum value I can write in cell D17 is 0.44 and the smallest value is 0.37. The largest value I can write in cell E17 is 0.4 and the smallest value is 0. If I enter values other than these values, excel will show me that I entered incorrect data.

If cell C17 contains "5140", the maximum value I can write in cell D17 is 0.45 and the smallest value is 0.38. The largest value I can write in cell E17 is 0.4 and the smallest value is 0.1. If I enter values other than these values, excel will show me that I entered incorrect data.

How can I do data validation like this?

Malzeme

C

Si

Mn

P

S

Cr

Ni

Al

Cu

Mo

V

Pb

N

Min

1040​

0,37​

0​

0,5​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Max

1040​

0,44​

0,4​

0,8​

0,03​

0,035​

0,4​

0,4​

0,3​

0,4​

0,1​

0,1​

0,4​

0​

Min

5140​

0,38​

0,1​

0,6​

0​

0​

0,9​

0​

0​

0​

0​

0​

0​

0​

Max

5140​

0,45​

0,4​

0,9​

0,025​

0,035​

1,2​

0,3​

0,3​

0,4​

0,08​

0,1​

0,4​

0​

Min

4140​

0,38​

0,1​

0,6​

0​

0​

0,9​

0​

0​

0​

0,15​

0​

0​

0​

Max

4140​

0,45​

0,4​

0,9​

0,025​

0,035​

1,2​

0,3​

0,3​

0,4​

0,3​

0,1​

0,4​

0​

Min

ST 37

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Max

ST 37

0,17​

0,6​

1,4​

0,04​

0,035​

0,3​

0,3​

0,3​

0,55​

0,08​

0,1​

0,4​

0,012​

Min

ST 52

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Max

ST 52

0,24​

0,55​

1,6​

0,035​

0,035​

0,3​

0,3​

0,3​

0,55​

0,08​

0,1​

0,4​

0,012​

Min

1008​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Max

1008​

0,1​

0,6​

0,5​

0,03​

0,05​

0,3​

0,3​

0,3​

0,4​

0,08​

0,1​

0,4​

0​

C

Si

Mn

P

S

Cr

Ni

Al

Cu

Mo

V

Pb

N

M16 1040

 

[Z51]

Take a look at this thread. Your "Score" column would be your list of possible "Malzeme" values, e.g. 1040, 4140, 5140, 1008, etc. You'd then put your specific min/max values in the 3rd/4th columns and use the VLOOKUP function for the min/max in data validation rules for columns D, E, etc.

Data validation range based on another cell contents

Hi All, I am having trouble with this one and feel like it should be easier than it is (for me) I want to have two data validation columns, Column C is whole no. 1 thru 6, Column D is a range % BASED on the result in Column C. So if C2 = 1, D2 only offers an input of 0%. However if C3 = 4, D3...

techcommunity.microsoft.com