How to assign contact with VLOOKUP?
Hello! I've been trying to get a contact assignment to work within my sheet and I'm not having any luck. I'm trying to have a contact automatically populate based on the site selected (in the same sheet and same row) so I can run an automation to notify said contact upon submission of a form. I initially thought this would be an IF function, but after looking up other similar scenarios I found that VLOOKUP function is the correct way of doing this, but I've never used this formula so I'm having some issues resolving the error. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!