How to Auto-populate cell based on selection of a list item

A

AK9955

Hi,
I'd like to know how to auto-populate the cells of a specific column, based
on the user selecting a particular list item from a list.

E.g. If user selects "No" from "Married?" list box, then "Years Married"
cell is auto-populated with "N/A".

Thanks
Anna
 
B

Bob Phillips

Just put a formula in those cells referring back to the list value

=IF(H1="No","N/A",some_calculation)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Help with drop down selection and populating related data... 9
Link a text box based on drop down box with four options MS Word 365 0
How do I designate dates using info from a cooresponding drop down list? 3
Auto populate from list on separate sheet 3
Drop Down Selection Assistance 2
Auto populate cell 3
Auto-populate spreadsheet based on database info? 1

Top