Format Excel Forms to auto populate another sheet and update information

Occasional Visitor

I am currently working on a project that uses a Microsoft Form. The sales team will fill out the form to add new projects or to update status of an existing project and the form exports the answers to a cloud based worksheet. I have all of the conditional formatting set up so that the information the sales team enters will be converted to a more digestible format, but I am struggling on how to figure out how to actually set up the formulas/functions.

What I am trying to do is set it up so when a new entry occurs on the Microsoft Forms sheet, I want Excel to check to make sure that the customer is not already entered into the Project Status sheet. If it is, I want the information to be updated, but if it is not I want it to add a new entry.

0 Replies