This is why I attached a file.
Perhaps you missed the part where I said "2. Please upload a sample of your workbook - to the forum, not a file-hosting site"

Also, please keep in mind that politeness is the order of the day here.

and I'm supposed to reference the columns in VLOOKUP from another sheet.
This seems to indicate that this is a homework assignment?