Related:
- What is the function of data validation in excel
- Excel data validation formula if statement - Best answers
- If function in data validation - Forum - Excel
- Using a data validation AND an IF formula in the same cell ✓ - Forum - Excel
- Excel data validation list multiple columns - Guide
- Excel - Data validation formula - How-To - Excel
- Excel force date format (dd/mm/yyyy) using data validation - Guide
3 replies
venkat1926
Jul 12, 2009 at 08:41 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jul 12, 2009 at 08:41 PM
am not sure whether I have understood your question correctly
according to me no need of a macro
you have validation in the cells E1 to E5 and also F1 to F5
type the following formula in D1
=IF(C1=B1,E1,F1)
if there is not entry in E1 or F1 (that is if you have not used the validation) then D1 will be zero
once you choose a validation is used to enter a value in E1 or F1 then D1 will change accordingly. try some experiments
copyp D1 down upto D5.
according to me no need of a macro
you have validation in the cells E1 to E5 and also F1 to F5
type the following formula in D1
=IF(C1=B1,E1,F1)
if there is not entry in E1 or F1 (that is if you have not used the validation) then D1 will be zero
once you choose a validation is used to enter a value in E1 or F1 then D1 will change accordingly. try some experiments
copyp D1 down upto D5.
I too need an answer for your question,,,, I have asked many no answer yet they say v cant do it, however am confident about excel there has to be a way for it
rizvisa1
Mar 26, 2010 at 12:03 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 26, 2010 at 12:03 PM
see if this helps
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
Mar 31, 2010 at 04:10 AM