You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Dynamic Lookup
- Thread starter Manuel998
- Start date
NARAYANK991
Excel Ninja
Hi ,
Which cell should have a formula ?
What should this formula do ?
Narayan
Which cell should have a formula ?
What should this formula do ?
Narayan
Which cell should have a formula ?formula should be in cell d31
What should this formula do ? Basically I need a dynamic lookup so if I change the parameters in the data validation then the formula will update this automatically eg if i choose mtd rather than wtd the formula should go in the mtd colum. Hope this makes sense the parameters are in the block named data validation parameters. Thanks in advance.
Narayan
What should this formula do ? Basically I need a dynamic lookup so if I change the parameters in the data validation then the formula will update this automatically eg if i choose mtd rather than wtd the formula should go in the mtd colum. Hope this makes sense the parameters are in the block named data validation parameters. Thanks in advance.
Narayan
Last edited by a moderator:
NARAYANK991
Excel Ninja
Hi ,
I am still confused ; the range C6:C14 is repeated in the range D6:D14.
There are 3 Data Validation dropdowns in C25 , C26 and C27 ; I have no idea what should be done with the dropdowns in C25 and C26.
You have mentioned that if C27 is selected mtd , then , and I quote :
It would all be crystal clear if instead of just xxxxxx all over the place , you could have some numbers , and then indicate what should be the value that should be output by the formula in D31.
Narayan
I am still confused ; the range C6:C14 is repeated in the range D6:D14.
There are 3 Data Validation dropdowns in C25 , C26 and C27 ; I have no idea what should be done with the dropdowns in C25 and C26.
You have mentioned that if C27 is selected mtd , then , and I quote :
I have no idea what this means , since WTD covers 3 columns , MTD covers 3 columns and YTD covers 3 columns.the formula should go in the mtd colum
It would all be crystal clear if instead of just xxxxxx all over the place , you could have some numbers , and then indicate what should be the value that should be output by the formula in D31.
Narayan
hi,
re attached. so the Exam Q is,
if I pick the parameters (from Data validation parameters) say e.g UK FSO TAS, FY18 Jul Wk 2 , WTD & Actual then cell D31 = 802. If i change the Parameters to UK FSO TAS, FY18 Jul Wk 2 , MTD & Plan D31 = 611.
re attached. so the Exam Q is,
if I pick the parameters (from Data validation parameters) say e.g UK FSO TAS, FY18 Jul Wk 2 , WTD & Actual then cell D31 = 802. If i change the Parameters to UK FSO TAS, FY18 Jul Wk 2 , MTD & Plan D31 = 611.
Attachments
Last edited by a moderator:
Naresh Yadav
Active Member
Hi,
pls tell us what is the significance of putting your parameters "FY18 Jul Wk2"
in C26 column
regards
Naresh
pls tell us what is the significance of putting your parameters "FY18 Jul Wk2"
in C26 column
regards
Naresh
Naresh Yadav
Active Member
Hi,
So far, I didn't understand the logic behind putting Data validation -Parameters (FY18 Jul Wk2),as it is not reflecting in your data range..
although I have tried from my end putting formula without including your parameter (FY18 Jul Wk2) and it is giving the same result which is required to you..
regards
Naresh
So far, I didn't understand the logic behind putting Data validation -Parameters (FY18 Jul Wk2),as it is not reflecting in your data range..
although I have tried from my end putting formula without including your parameter (FY18 Jul Wk2) and it is giving the same result which is required to you..
regards
Naresh