• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation

K

KushBhargava

New Member
In a column 'A' only K can be written and if enter K in any cell i want in the column 'B' adjacent to that cell there would be K also and if nothing in column 'A' then there should be nothing in column 'B' too. Same i have to do As in column 'C' in any cell if i enter a 10 digit number then the value of adjacent column ie 'D' will have the value "MOBILE".
 
Hi kushbhargava,


Put this formula in column "B" =IF(A2="K","K","")


and Put this in column "D" =IF(LEN(C2)=10,"Mobile","")


and drag the formula to your desired row.


Thanks


Sreekhosh
 
Sreekhosh, thanks for the answer but there is some more conditions that should meet.

Your Solution

"B" =IF(A2="K","K","")

working fine but in column A, the user can enter K or leave blank. The Value of column B fully depends on column A. if in column A the value is K then the adjacent cell will have either K or blank but if the column A is blank then the Column B must also be blank.
 
Hi KushBhargava,


Can you please upload your sample workbook here,


http://chandoo.org/forums/topic/posting-a-sample-workbook


so that people can easily work on it.


Thanks


SReeKHosH
 
You must log in or register to reply here.
Back
Top