I need a formula that will update my report based on cell info.
Formula needs to be applied across whole report in Summary tab, and be able to pull data from DATA sheet.
Please see attached example.
I need a formula that will update my report based on cell info.
Formula needs to be applied across whole report in Summary tab, and be able to pull data from DATA sheet.
Please see attached example.
Last edited by jimstrongy; 12-09-2015 at 01:06 AM.
What formula are you using? Where is it to be found in the workbook, please?
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
in B5
=INDEX(DATA!$D$3:$O$30,MATCH(1,(DATA!$B$3:$B$30=RIGHT($A5,3))*(DATA!$A$3:$A$30=B$4),0),MATCH(Summary!$C$1,DATA!$D$2:$O$2,0))
in B6
=INDEX(DATA!$D$3:$O$30,MATCH(1,(DATA!$B$3:$B$30=RIGHT($A6,5))*(DATA!$A$3:$A$30=B$4),0),MATCH(Summary!$C$1,DATA!$D$2:$O$2,0))
Enter both with Ctrl+Shift+Enter
Copy across both rows
FORGOT to say I changed DATA dates to proper dates (01/01/2015) formatted as "mmm"
Last edited by JohnTopley; 12-08-2015 at 02:18 PM.
I'm not using any formulas, I need one.
See attached.
I changed data in DATA to date format with Custom format of "mmm"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks