Using GPT for sheets. I need a prompt that allows the following... There are two sheets in the one spreadsheet. We're trying to match a company from the second sheet called Reference with a company in the first sheet called Email based on the companies' similarities as described in the corresponding row in column O of Email sheet and in column F of Reference sheet. The first sheet is called "Email" and the second sheet is called "Reference" - the output ie the chosen company needs to be input in the column P of the Email sheet. In both sheets the company name is in column A. Here’s a summary of the requirements: My Goal For each company in the "Email" sheet is to find the most similar company from the "Reference" sheet. Similarity is based on: "Email" sheet: column O and "Reference" sheet: column F. Output: Write the name of the most similar company from "Reference" into column P of the "Email" sheet, for each row.
Power Platform Certification Backend Build Category: Backend Development, Business Analysis, Data Integration, Data Modeling, Database Design, Database Management, Dynamic 365, PowerApps, Project Management Budget: $25 - $50 CAD
24 Jan 2026 22:50 GMT
Social Media On-Street Promoter Category: Digital Marketing, Facebook Marketing, Fashion Modeling, Lead Generation, Sales Promotion, Social Media Management, Social Media Marketing, Twitter Budget: €750 - €1500 EUR
24 Jan 2026 22:47 GMT
MBA Assignment Writing Support Category: Academic Writing, Business Writing, Finance, Management, Research, Research Writing Budget: $30 - $250 USD
