Skip to main content

Hi, apologies that this may be fairly straightforward but I am struggling to find a solution.

 

I have a Zap, that updates the 2nd row values for columns 1 and 2 based on a new form submission. The Excel sheet then has a formula to calculate the amount in USD based on the value and currency inputted from the form. The value is presented in Row 2, Column 3. 

 

All I would like to do is output the value of Row 2, Column 3 so that I code feed that into Code by Zapier. Could anyone advise on how to do this?

 

I can do this quite easily using Google Sheets - get many rows action. But I can’t seem to find this functionality for Excel.

 

Thank you in advance!

 

 

Hi @pjackson 

Unfortunately, the Excel Zap app has less/limited options compared to using GSheets in Zaps.