Lookup text and calculate values in cells from columns in the same row

John Renney

The formula I'm using for this is working, but it feels like it could be completed in an easier way.

I want to look up the text "Grand (Total)" from the Rows column then divide the numbers from the Audits and Findings columns in the same row.

Any suggestions on how I could shorten this formula?

Paul Newcome

That is about as simplified as it gets unless you wanted to start working with helper columns.

Paul Newcome

That is about as simplified as it gets unless you wanted to start working with helper columns.

John Renney

Thanks for taking a look @Paul Newcome

Paul Newcome

Sure thing. 👍️