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!