Hi, this is an excel question. I am trying to match the hotel state to the taxes tab using an IF statement to be able to pull the HST GST and QST. HST AND GST should be included together. QST pull separate. I have highlighted the area that needs the data.

For example, if you take the first one which the state is AB, you would know that the tax is 7.30 from the excel sheet, i know this is the answer, but I need to create an IF statement that auto populates it for you. So the IF statement would need to auto calc the tax for each state

Hotel State AB BC NB NB NS PE ON BC ON AB NS QC ON ON AB Amount HST/GST $153.21 $2,066.27 $159.85 $158.35 $197.21 $197.21 $161.24 $180.04 $394.42 $163.92 $174.78 $410.80 $394.42 $394.42 $334.56 QST Newfoundland ON Inclusive Inclusive HST GST QC Inclusive Inclusive GST & QSGST 13% Tax Tax Input Amount 5% Tax $ - Input Amount 5% Tax $ - Input Amo GST 1690 $ - $ - GST 1690 $ QST 1691 $ - $ - GST 1690 W/O Taxes $ - $ - W/O Taxes $ - $ - W/O Taxes Total $ - $ - Total $ - $ - Total AB Inclusive GST BC Inclusive Inclusive GST & PS GST PE Inclusive HST 5% Tax 12% Tax 14% Tax $ 153.21 Input Amount $ GST 1690 $ 5% Tax $ - Input Amount $ - HST 1690 $ - HST 1690 $ - $ 145.91 W/O Taxes $ - $ - W/O Taxes $ - W/O Taxes $ 153.21 Total $ - $ - Total $ - Total 7.30 PST Input Amount NS NB Inclusive HST 15% Tax Input Amount $ - $ - $