How to Auto-populate cell based on selection of a list item
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 |
How to Auto-populate cell based on selection of a list item
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) "AK9955" wrote in message ... 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 |
How to Auto-populate cell based on selection of a list item
Hi,
Excel -- Data Validation -- Create Dependent Lists. Use this URL: http://www.contextures.com/xlDataVal02.html Challa Prabhu "AK9955" wrote: 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 |
All times are GMT +1. The time now is 07:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com