Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
Hello I defined a name range for certain values & using the named range in Data validation. So that I can enter only those values which are associated with that value.
I have Two sheets DATA & RAW DATA
In RAW DATA sheet in Column B & C I am entering values manually which are linked with DATA sheet through Name manager & using the formula =MATCH(C2,INDIRECT(B2),0)
with the above formula if I write any Wrong value in C2 which are not linked with B2 then I am getting Error message.
Similarly I want that IF in the DATA sheet if Column H=0 or "" then I can not enter any value in column HIJKL of RAW DATA, so what should be the code ??
I have Two sheets DATA & RAW DATA
In RAW DATA sheet in Column B & C I am entering values manually which are linked with DATA sheet through Name manager & using the formula =MATCH(C2,INDIRECT(B2),0)
with the above formula if I write any Wrong value in C2 which are not linked with B2 then I am getting Error message.
Similarly I want that IF in the DATA sheet if Column H=0 or "" then I can not enter any value in column HIJKL of RAW DATA, so what should be the code ??
