Once you input this info in the Table you will need to go and name that table : DateCheckTable

Select all the table, go in the top left name box and change the name to DateCheckTable

Once this is done you will be able to go in a new collumn and try out your Vlookup! Type out

=VLOOKUP(B2,DateCheckTable,2)

You will notice a bunch of Late's and a bunch of Still on time!

Wow awesome, if you did this properly you should have 2 collumns one that shows the paids and the other ones the still on time.

You can combine both these formulas by running an IF inside of the UNPAID section of the IF to check if they are late or not! And if they aren't get the right labels!

=IF(G2<>"","PAID",IF(VLOOKUP(B2,DateCheckTable,2)="Late","LATE & UNPAID","INVOICED"))

Here's it read in plain english - IF cell g2 is not empty, put "PAID" in the cell or else run a vlookup to check if it's late or not. And if it's late, put "LATE & UNPAID" or else it has to be "INVOICED".

It works!

When it comes to the 🌶Spicy Challenge🌶 That's a whole other ballgame.

To do this you will need to create a formula in the Conditionnal formats of your entire table!

Here are the steps and a handy GIF to help you out!

SELECT CELL A1
HIT CTRL - A
GO TO CREATE CONDITIONNAL FORMAT AND CHOOSE FORMULA
TYPE =$H1="PAID"
SET THE COLOR OF THE FONT TO GREEN

Do it again and change "PAID" by "LATE & UNPAID" and set the color of the font to RED

If you would rather see it:

	3.4	Provincial Taxation with Vlookup
	3.5	Tracking better with dated IF's
	3.6	Index Match Shipping Prices
	101.1	My first OneNote Notebook
	101.2	Set-up your e-mail
	101.3	PowerPoint/Outlook Presentation
	101.4	Make a sendable training presentation

PRACTICE YOUR SKILLS WITH THESE FREE EXERCISES🤗