Need help writing formula

[DKRbella0814]

I have a workbook which contains two spreadsheets

spreadsheet 1 = 'SweetSpotCalculator'

spreadsehet 2 = 'MfgData'


Spreadsheet 1 has a number of data points which need summarized from the 'MfgData' sheet through use of formulas. Two specific data points that need to be summarized are the following:

-Constraint Operation = Longest Run Time (minutes per piece MPP)

-Associated S/U Time of the Constraint Operation (hrs)


On the 'MfgData' worksheet, the information is arranged as follows:

col A = Job#
col B = Customer
Col C = Op 10
col D = S/U time - op 10
col E = Op 20
col F = S/U time - op 20
col G = Op 30
col H = S/U time - op 30
col I = Op 40
col J = S/U time - op 40
col K = Op 50
col L = S/U time - op 50


For the first data point on the 'SweetSpotCalculator' worksheet, I have written the following formula to return the value of the operation with the longest run time:

=Max(vlookup(Job#(relative cell reference on curr worksheet), 'MfgData'!$a$2:$l$20,3,false), vlookup(job#, 'MfgData'!$a$2:$l$20,5,false),
vlookup(job#, 'MfgData'!$a$2:$l$20,7,false),vlookup(job#, 'MfgData'!$a$2:$l$20,9,false),vlookup(job#, 'MfgData'!$a$2:$l$20,11,false))


What I would now like to do is to write a formula to return the value of the associated S/U time of the longest running operation (which will always be 1 column to the right of the column with the longest running op); the issue is that the above formula returns the VALUE of the longest running op and not the CELL REFERENCE.

Can someone please help me out?