Help with Formula to check data

[Pi*]

Good evening,

I humbly request your expertise with a formula to solve my dilemma. I have a workbook with more than 79 tabs all showing accounts Sales, Gross Margin, Expense etcetera for several periods of the year. I also created a Summary tab that displays all the accounts data for all the periods on this tab so that end-users wouldn't have to keep moving from tab to tab. A sample of my report is attached and this is my dilemma explained below;

I am trying to figure out a formula perhaps on the Summary tab that would validate/check to make sure the numbers I am pulling for all the accounts (LY Sales, Other Revenue, Total Revenue...) for all the periods on the Summary tab, matches exactly what is displayed in the individual tabs (only for periods Feb - Full Year) when the drop down account is selected in cell B2 on the Summary tab.

I hope my request make sense. Without this check, I would essentially have o check each individual row of business (Alpha, Beta, Gamma...) on the Summary tab to make sure it ties out with the specific account as the the drop-down accounts in cell B2 on the Sample tab changes. If the results of your formula could change/update accordingly as the drop-downs of accounts is selected that would be great.

Thank you for your help.

[humdingaling]

your formula in column A is unnecessarily long

i have inserted a check into your example though isnt it just another way of writing the formula?

[Pi*]

Brilliant!

You are right. It's just another formula I couldn't figure out. Thank you for your assistance and time.

You solved my dilemma.

[humdingaling]

not a problem
glad to help