Zapier - Google Sheet - Pick a Value from a Matrix by Intersecting Rows and Columns
Budget €30-250 EUR
Pick a Value from a Matrix by Intersecting Rows and Columns
Hello, nice to meet you!
I have the following concern:
It's about a Google Sheet I created, in it in the 1st row are listed values (modernization points) from 0 to 18.
In column A there are about 135x values listed, there it is about building age.
I want my Zap to see this table as a matrix. If I have a building age of say 45 years and 5x modernization points, I want the Zap to check the rows and columns and give me the value where the intersection is (42.25 in this example).
Please take a look at the attached image for understanding.
I would greatly appreciate any assistance....
9 freelancers are bidding on average €82 for this job
Hi I can do this with google app script.. Just want to know the calculation behind 42.25 in this example so that i can generalise it for other values as well If you are interested ping me in chat Thanks Vishal
Hello! Hope you are happy. As a Zapier expert, I am sure I can help your perfectly. If you hire me I 'll do my best for you with my sincere work. Looking forward to working with you.
Hello, I am an Excel / Google Sheets expert. I have checked the attached pdf image and offer my services to create formulas to pick a Value from a Matrix by Intersecting Rows (135x) and Columns (0 to 18). You can chec More
Hi there, I am a full stack developer with 4+ years of experience in both front-end and back-end development. I have read your Zapier - Google Sheet - Pick a Value from a Matrix by Intersecting Rows and Columns descrip More
Tech Setup, Integration, & Automation Expert I am very excited to inform you that i have built several Triggers and Zaps. With my experience, i can help you create smarter workflows between your Leads and the business More