FY 19 FY 20 FY 20 Hotel Visitor admission A Hotel Visitor admission A B c D Total visitor in my hotel 60 40 90 30 20 45 20 60 30 20 90 45 40 20 =13+14+15 c D Total visitor in my hotel 40" =B3-B5 =C3+C5 =43+H4+HS if the above table category B (green)change to E(green) cant simply use sum formula (no manual correction) Question la : sum up the FY table if the hotel ABCD exactly match with the reference table (using vlookup/ if functions) Qib: use if/vlookup function to match the amount of visitor admission each category the expense fee . Yearly Expense =83*819+84*+85B20-860 (according Qia) Requirement: cell must be flexible and efficient, Please help me to refine the answer using vlookup/if/and function Reference table Hotel under my asset Yearly Expense A 4,500.00 650.00 E no inccured G no inccured 750.00 F FY 19 FY 20 FY 20 Hotel Visitor admission A Hotel Visitor admission A B c D Total visitor in my hotel 60 40 90 30 20 45 20 60 30 20 90 45 40 20 =13+14+15 c D Total visitor in my hotel 40" =B3-B5 =C3+C5 =43+H4+HS if the above table category B (green)change to E(green) cant simply use sum formula (no manual correction) Question la : sum up the FY table if the hotel ABCD exactly match with the reference table (using vlookup/ if functions) Qib: use if/vlookup function to match the amount of visitor admission each category the expense fee . Yearly Expense =83*819+84*+85B20-860 (according Qia) Requirement: cell must be flexible and efficient, Please help me to refine the answer using vlookup/if/and function Reference table Hotel under my asset Yearly Expense A 4,500.00 650.00 E no inccured G no inccured 750.00 F