VLOOKUP - Pulling from one sheet to another based on matching values

[rpreen1982]

I am sure I am doing something simple wrong but I have been staring at this for a while and am just missing it.

I have attached an example.

Simply I am needing the Invoice # (Cell B2) from the "Vendor Inv." Tab returned on the FL tab (under "Invoice" header in column F) if the corresponding "Ticket" number in column B on the FL tab appears anywhere in merged column "DE" on the "Vendor Invoice" tab.

My extra was going to be if the "Ticket" number from the "Vendor Inv." tab Does NOT appear on the FL tab then it would change color or somehow indicate that it is not there. That would but I have no clue how to do that.