excel formula help
Budget: £10 – £15 GBP
I got a dashboard where all information is taken from other sub sheets using formulas.
I cut excel file and left only 2 tables where formula takes effect for this work to make it easier.
(master sheet) is my dashboard where information is shown
(rapP sheet) is where target information is filled manually.
Right now i got one drop down for (month field) A1 and formula i works fine.
Now my goal is to have 2 drop down cells with Month and Region code. so every time you select specific month and region repair plan number should change accordingly.
Current code is:
=VLOOKUP($A$4, rapP!$A$2:$M$74, MATCH($A$1, rapP!$A$1:$M$1, 0), FALSE)
i dont know how to add 1 more match into this formula.
help me finishing this code or reorganize repP sheet to make this work.
I cut excel file and left only 2 tables where formula takes effect for this work to make it easier.
(master sheet) is my dashboard where information is shown
(rapP sheet) is where target information is filled manually.
Right now i got one drop down for (month field) A1 and formula i works fine.
Now my goal is to have 2 drop down cells with Month and Region code. so every time you select specific month and region repair plan number should change accordingly.
Current code is:
=VLOOKUP($A$4, rapP!$A$2:$M$74, MATCH($A$1, rapP!$A$1:$M$1, 0), FALSE)
i dont know how to add 1 more match into this formula.
help me finishing this code or reorganize repP sheet to make this work.