I have a named range in an Excel sheet called Commissions. I'm using the following formula to look for company names in Commissions in order to determine which invoices should have commissions paid on them.
=IF(C3=(VLOOKUP(C3,Commissions,1,FALSE)),"Y","")
The formula...