I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row.
here's what I've tried...
=IF([Name of Business]@row = {Recall Business Contacts final Range 3}, {Recall Business Contacts final Range 4})
I keep getting invalid operation.