Skip to main content
Question

Use Values in 2 Google Sheets to update a Specific Row Value (VLOOKUP)

  • June 23, 2020
  • 1 reply
  • 47 views

I am trying to look up a value in google sheet 1 using 2 values (customer email and sales person name) and then correlate that row and sales person’s name to pull in the sales person’s email address.  I can do it easliy with a vlookup, but i can’t get the row value to of the vlookup to increase by 1 each time to maintain the correct reference.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • June 29, 2020

Hi @ChrisRager ,

Thanks for reaching out! I see that you have a great conversation going with Caleb in Support- I will let them continue to assist with this workflow and circle back to update this thread with the resolution. 

 

Let us know if you have any additional questions!