I was helped previously by DLL with this formula:
This formula would pull data from various sheets depending on the user selection in the dashboard (the branch selected). If all branches are selected then it would need to sum all the branches together – I will come onto this as I have a problem with it...
I now need to add in an additional match function, can anyone help with this please?
I need it to match cell B67 (on the “calcs” sheet) with Column B on the corresponding sheet (e.g payables/inventory/receivables).
I have highlighted the cell where I need the formula in orange.
The other problem I have is that when ALL branches are selected it doesn’t add up correctly despite each branch being correct – why would this be? e.g. if you select branch 1 on the dashboard the forumla returns the correct data however if all is selected it pulls a number in and I dont know where this is from.
Can anyone look into this please?