Excel Formulas - Searching the address of the max ABS formula result

Hi, 

I have a cell that contains a formula (max absolute value) taken from a range of cells with multiple rows and columns.

In another cell, I am trying to find out the value in longitudinal and horizontal cells at a distance from the cell containing the MAX Abs value in the original range of cells.

• E.g., If the max ABS value is in cell C10, I want to know what the text in C3 and A10 are - and populate them into a specific set of cells (e.g., H20 and I20).
• So what I would like this to look like is 3 new cells in the same row with: Max value = 3.07 (I already have this formula set up), 12-14 (text in cell C3), 30L40R (text in A10).

I need this formula to apply across several spreadsheets, so I need something that will automatically detect the maximum number from a specified range (of multiple rows and columns), since I cannot give it exact cell coordinates such as C10 (as the location of the maximum value will vary each time depending on the data set).

Additionally, I need to do the same thing again, but this time, the maximum value might be present in 2, 3 or more cells in a single row. 

I have done several searches, but all the instructions so far have been about searching in a single column. Since I am searching across multiple columns, I'm not sure how to do this. Is there such a function in excel? (I'm anticipating combining some formula types might help). 

I am using Microsoft 365 for enterprise version 2102, on an HP laptop with Windows 10 OS. Context: I am using this for a research project with thousands of data points per participant.