Table value help

Hello all, I'm looking for some help on how to fill a cell with a matching result from a calculated cell.

Here is a brief look at where I'm at so far.

I have this expression to tell me which value in a few different tables is the highest:
=MAX(Table01[[#This Row],[Max Efficiency]],Table02[[#This Row],[Max Efficiency]],Table03[[#This Row],[Max Efficiency]],Table04[[#This Row],[Max Efficiency]],Table05[[#This Row],[Max Efficiency]],Table06[[#This Row],[Max Efficiency]],Table07[[#This Row],[Max Efficiency]],Table08[[#This Row],[Max Efficiency]],Table09[[#This Row],[Max Efficiency]],Table10[[#This Row],[Max Efficiency]],Table11[[#This Row],[Max Efficiency]],Table12[[#This Row],[Max Efficiency]],Table13[[#This Row],[Max Efficiency]],Table14[[#This Row],[Max Efficiency]],Table15[[#This Row],[Max Efficiency]],Table16[[#This Row],[Max Efficiency]],Table17[[#This Row],[Max Efficiency]],Table18[[#This Row],[Max Efficiency]],Table19[[#This Row],[Max Efficiency]],Table4678910111213141516171819420222324[[#This Row],[Max Efficiency]],Table21[[#This Row],[Max Efficiency]],Table22[[#This Row],[Max Efficiency]],Table23[[#This Row],[Max Efficiency]],Table24[[#This Row],[Max Efficiency]],Table25[[#This Row],[Max Efficiency]],Table26[[#This Row],[Max Efficiency]],Table27[[#This Row],[Max Efficiency]],Table28[[#This Row],[Max Efficiency]],Table29[[#This Row],[Max Efficiency]],Table30[[#This Row],[Max Efficiency]],Table31[[#This Row],[Max Efficiency]],Table32[[#This Row],[Max Efficiency]],Table33[[#This Row],[Max Efficiency]],Table34[[#This Row],[Max Efficiency]],Table35[[#This Row],[Max Efficiency]],Table36[[#This Row],[Max Efficiency]],Table37[[#This Row],[Max Efficiency]],Table38[[#This Row],[Max Efficiency]])

and I want to match the corresponding Type value in the same row as the deterined Max Value:
Max Efficiency CTN 01 L/L Efficiency L/L W/W CTN 01 QTY L/L CTN 01 L/W Efficiency L/W W/L CTN 01 QTY W/L Type



Any ideas?

Will Index and Match be a better command to search and match values?

Hi
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
By the way, have you try to simplify your formula to
=MAX(Table01[Max Efficiency]:Table38[Max Efficiency]) ?

I do not know if is this what you want but I try. See if this helps you

In a column, select 38 cells and use the following array formula

Formula:

Please Login or Register  to view this content.

Use that column to get the max and the position of the max.
Note:Formula must be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Here is a sample of the workbook and how id like the results to be displayed. Carton PN to display the result of the matching max efficiency value from the specific table.

Label Size Length Label Size Width Max efficiency Carton PN
20.375 3.6875 76%
20 7.15 68%
19.875 5.625 75%

I'll upload the file shortly, the system said the file is too large.

Hi

The solution I propose uses a helper table in sheet MaxEfficiency with as many columns as the number of tables (Table01:Table38 from A:AL) and as many rows as LabelSizes data rows.

In that table, row 1 is header
Select A2:AL2 and use the following array formula and drag down:

Formula:

Please Login or Register  to view this content.

In Label_Sizes sheet use in C2 the following formula

Formula:

Please Login or Register  to view this content.

see the file
Note: To calculate max efficiency by row using all tables you can use =MAX('CTN 01:CTN 03'!F2) for 3 tables or =MAX('CTN 01:CTN 38'!F2) for 38 tables