How to select Exact values under Dependent Rows?

[Jyotirmaya]

for example
I have two Sheets "DATA" "RAW DATA"

In DATA sheets

[TABLE="width: 500"]
<tbody>[TR]
[TD]
APPLE[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]16.5[/TD]
[/TR]
[TR]
[TD]BANANA
[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]BANANA[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]BANANA[/TD]
[TD]36[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]45
[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]111[/TD]
[/TR]
</tbody>[/TABLE]

In RAW DATA sheet in Column B I have to input APPLE/BANANA/ORANGE in various rows.

I want that if in B2 I have entered APPLE then in C2 I can enter only 10 or 15 or 16.5 if anything else I will enter then I will get error message that enter correct value. Similarly If I will enter Banana in column B of Raw Data sheet then I can only input values 35 or 20 or 36 in the column C

SO what will be the code for Column C of Raw Data sheet to do so ?​

 

[pgc01]

Re: Excel Help.. How to select Exact values under Dependent Rows?

... or

- Select C2:C100
- Data Validation, Custom Formula: =MATCH(C2,INDIRECT(B2),0)

 

[Jyotirmaya]

Re: Excel Help.. How to select Exact values under Dependent Rows?

hi

- copy c2
- select c3:c100
- paste special -> validation

thanks

 

[pgc01]

Re: Excel Help.. How to select Exact values under Dependent Rows?

You're welcome.

 

[Jyotirmaya]

Re: Excel Help.. How to select Exact values under Dependent Rows?

Hi


If you want to enter the values manually and just make sure they are correct,then in 'RAW DATA'!C2 in the data validation instead of the list use the custom option and enter the formula:




=MATCH(C2,INDIRECT(B2),0)


If you try to enter a value different from 15, 25 e 26 you'll get an error pop-up


Does it help?

hello pgc01


similarly like the above I need some more help. If in the DATA sheet H column value will be more than 0 then Only in Raw Data sheet I can enter any value in Column H I J K L else it will show mw error pop-up.