Hi
I need the info in perfor datasheet to pick up all the information regarding budget, actual and variant for a particular month when selected in cell B1
The information is picked up from the budget datasheet
Hi
I need the info in perfor datasheet to pick up all the information regarding budget, actual and variant for a particular month when selected in cell B1
The information is picked up from the budget datasheet
c3 =INDEX(budget!$A$5:$AB$123,match(perfor!A3,budget!$A$5:$A$123,0),17) and drag down
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
that is not working
and the answers should be populated by the month. So if b1 in perfor spreadsheet is feb-16, should only display the answers for that month
actual and variant?
why it is not working?
what failure do you get?
what did you expect as result?
where do we find the actual and variant data in your example?
it is working now but need it when the user select a month from the drop down box in b1 it populates those answers for just that month
any idea on this
then change the 17 in the give formula into
match($B$1,budget!$Q$5:$AB$5,0)
please reply.
Oeldere (edit)
See the amende formula in #14.
match($B$1,budget!$A$5:$AB$5,0)
Last edited by oeldere; 02-15-2016 at 12:38 PM.
that came back with Core Sales
Core Sales Accrual
Total Core Sales
as the results
that does not work
why it is not working?
what failure do you get?
what did you expect as result?
where do we find the actual and variant data in your example?
post the amended excel file, so we can take a look at it.
see uploaded
then change the 17 in the give formula into
match($B$1,budget!$A$5:$AB$5,0)
See the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks