Finding Max Value in Table with Gaps & Find Assoc. Value

[Formula9]

I have a table from E108 to M129. It is made up of three sets of data (E108:G129,H108:J129,K108:M129). some cells contains text. Some cells contain neg values.
Q1: How to find the max value from cells in G, J, and M column of table?

I have tried the following and it works if I look down only one column. But if I extend the list by adding cells in the J and M column within "max" and extend the range from G108:G129 to G108:M129, I get #N/A.
=INDIRECT(ADDRESS(MATCH(MAX(abs(G108),abs(G111),abs(G114),abs(G117),abs(G120),abs(G123),abs(G126),abs(G129)),G108:G129,0)+107,7)). What am I doing wrong?

[FDibbins]

Hi and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Formula9]

I have attached a sample as suggested. Please excuse me if I am not following the proper protocol.

[Formula9]

I just found another way online but it does not work if the max number is negative. I get the error "#value!":

=ADDRESS(MAX((G108:M129=I138)*ROW(G108:M129)),MAX((G108:M129=I138)*COLUMN(G108:M129)),4)

[Formula9]

I figured out why the equation on my last post (post 3) shows an error. It seems to be because while the actual value in the table is negative, my target (I138) has a formula that contains max(abs(G108,G111, . . .). So since it cannot find the positive value shown in I138, only the neg. version, the test fails. So, if there is a way to get back the correct sign from the table into I138, the equation will work, and I just need to add "=indirect(address . . .)" and I am good to go.

Sorry folks if I have confused anyone. Any suggestions would be welcomed. Thank you.

[Formula9]

I just found a post from Daddylonglegs & Cutter, on 02-09-11, subject: Re: Returning greatest (absolute) value, including negatives. Now I can use the equation of post (3) above.
=IF(ABS(MIN(E2,J2,M2))>MAX(E2,J2,M2),MIN(E2,J2,M2),MAX(E2,J2,M2))

Thank you FDibbins for suggesting to post a sample workbook. I'll consider that first thing next time I post another question.