LinkBack URL
About LinkBacks
Hi,
I have a worksheet where I data validation list
I would like calculate data based on selection from data validation list.
I have attached a sample workbook with the desired results.
Any help or direction will be appreciated.
Thank you
Calculation Based on Dropdown Selection
Hi,
I have a worksheet where I data validation list
I would like calculate data based on selection from data validation list.
I have attached a sample workbook with the desired results.
Any help or direction will be appreciated.
Thank you
Try this:
=HLOOKUP($E$9,$A$2:$Q$6,3,0)*IFNA(LOOKUP(LEFT(E9,1),{"S","Q","Y"},{2,3,1}),12)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
CORRECTION (because of SEP):
=HLOOKUP($E$9,$A$2:$Q$6,3,0)*IFNA(LOOKUP(LEFT(E9,3),{"Sem","Qua","Yea"},{2,3,1}),12)
Last edited by AliGW; 03-09-2022 at 10:06 AM.
Try this
=HLOOKUP($E$9,$A$2:$Q$6,3,0)*(IFERROR(INDEX({1,2,4},MATCH(E9,C9:C11,0)),12))
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Another optionbut you need to change the dropdown for "Semi Annually" to match the value in P2Formula:
Please Login or Register to view this content.
That works perfectly !
This is great...thank you for your help...!
Don't know which of us are you talking to, but glad to help & thanks for the feedback.
Thanks for the rep.
I am sorry @Fluff13.Originally Posted by Fluff13
All formula worked well. Thank you everyone for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks