Excel Formulas for FA-2-4 (Please only look at the formulas below when Chris asks you to):

EXERCISE A:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE B:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE C:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE D:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE E:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE F:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE G:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE H:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE i:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

EXERCISE J:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATEWEBSITE,FALSE),"Taxes are due in "&YOURCOUNTRY&" on "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYTAXDATE,FALSE)&" and you can click on me to go to the website that shows this date and other tax information."),HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&" when are taxes due","Click me for details on when taxes are due in "&YOURCOUNTRY&"."))

_______________________________

EXERCISE K:

=HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&"+annual+personal+tax documents+to+file","Click me for tax documents to file in "&YOURCOUNTRY&".")

EXERCISE L:

=HYPERLINK("https://www.google.com/search?q="&YOURCOUNTRY&"+wage+and+tax+statement","Click me for tax wage documents to file in "&YOURCOUNTRY&".")

EXERCISE M:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURGOVERNMENTTAXAGENCYWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURGOVERNMENTTAXAGENCYWEBSITE,FALSE),"Your government tax agency in "&YOURCOUNTRY&" is the "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURGOVERNMENTTAXAGENCY,FALSE)&" and you can click on me to go to their website."),"")

EXERCISE N:

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURRETIREMENTPROGRAMWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURRETIREMENTPROGRAMWEBSITE,FALSE),"Your government's retirement savings program in "&YOURCOUNTRY&" is called the "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURRETIREMENTPROGRAMNAME,FALSE)&" and you can click on me to go to their website."),"")

EXERCISE O (FOR OH NO, I AM NOT CONFUSED ANYMORE):

=IF(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYEDUCATIONSAVINGSPROGRAMWEBSITE,FALSE)<>"",HYPERLINK(VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYEDUCATIONSAVINGSPROGRAMWEBSITE,FALSE),"Your government's education savings program in "&YOURCOUNTRY&" is called the "&VLOOKUP(YOURCOUNTRY,ALLCOUNTRYDATA,YOURCOUNTRYEDUCATIONSAVINGSPROGRAM,FALSE)&" and you can click on me to go to their website."),"")