Populating Cells with "N/A" based on another cells input

[Jimborusk13]

So ive made a checklist an i am now trying to add formulas that make it user friendly and more efficient. Ive attached a snapshot to reference as i talk through what i am in need of. When the user is going down the checklist each cell in column C contains a pulldown list to make the selection. Based on the selection made in Cell C77 would determine which of the next 3 sections need to be used, in the snapshot that identified as the letters Section A, Section B, & Section C in the gray heading rows. So in the snap shot "C" is selected in cell C77, i would want the checklist items appearing in Sections A & B to auto populate with "N/A", and the items in section C to remain blank so they can be processed by the user. If C77 was populated with "B" then cells in Section A & Section C would be populated with "N/A".

I hope that makes enough sense to get my idea.
If you have any other questions please let me know

Thanks

 

[s_macloskey]

.

 

[s_macloskey]

Hi mate,

Assuming the cell that gets filled in with "a b or c" is C77 (you can change the formula accordingly if not),

In C79, C80, C81 (section a):

=IF(OR(C77="C",C77="B"),"N/A","")

In C83, C84, C85 (section b):

=IF(OR(C77="A",C77="C"),"N/A","")

In C87, C88, C89 (section c):

=IF(OR(C77="A",C77="B"),"N/A","")

This leaves one possible problem, when the cells are filled out by the user, it will remove the formula. Perhaps consider inserting another column next to the cells that says N/A, pointing to the cell? Unless once the form is filled in, it doesn't matter too much?

I hope this helps.

S Macloskey

 

[Jimborusk13]

one possible problem, when

Hi mate,

Assuming the cell that gets filled in with "a b or c" is C77 (you can change the formula accordingly if not),

In C79, C80, C81 (section a):

=IF(OR(C77="C",C77="B"),"N/A","")

In C83, C84, C85 (section b):

=IF(OR(C77="A",C77="C"),"N/A","")

In C87, C88, C89 (section c):

=IF(OR(C77="A",C77="B"),"N/A","")

This leaves one possible problem, when the cells are filled out by the user, it will remove the formula. Perhaps consider inserting another column next to the cells that says N/A, pointing to the cell? Unless once the form is filled in, it doesn't matter too much?

I hope this helps.

S Macloskey

Awesome! i appreciate the quick help once that form is filled-in it wont be touched again so that doesn't matter. Thank you again

 

[s_macloskey]

Awesome! i appreciate the quick help once that form is filled-in it wont be touched again so that doesn't matter. Thank you again

Good stuff,

I'm glad I could help.

S Macloskey