Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel/Sheets: Index of a data validation list.?
I am curious if there is a function in ms excel or google sheets to find the index of a drop down data validation list. I am trying to make a spreadsheet with my bills and if I pay something monthly I want it to take the value and display it over 12 months; quarterly 1/3 the values of 12 months; yearly 1/12 the value of 12 months.
I am using sheets so that would be prefered, but if anyone knows how to do something like this in excel I can reverse engineer in. Right now I have embedded IF statements which isn't ideal.
1 Answer
- NahumLv 77 years ago
You can't index a data validation list directly, but you can use a cell range or a named range (Ctrl+F3) for data validation and INDEX.
Nested IF statements are indeed a poor choice when INDEX(MATCH) and other lookup functions are available.
