VLOOKUP with IF across 2 sheets

Hello, I have a workbook that has multiple sheets.  One of the sheets if named TICKETS. It has columns A thru J and has 501 rows.  Columns A has unique ticket numbers, the other columns are details ...