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

G

Guest

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 Based on Other Selection 2
Auto populate cell 3
Selection of drop down list directs auto population of other cell 1
How do I auto populate based on a drop down list? 0
Best method to populate cell based upon drop down list selection 4
auto populate cell based on previous cell drop down list selectio. 2
auto populating a cell based on another cell for an invoice 3
Auto Populate fields based upon dropdown selection 4

Top