All, I am trying to get the following command to work: =OFFSET((LARGE(B34:M34,2)),-33,1,1) Can anyone tell me why I cannot get it to work? Any help would be greatly appreciated Scott

Well, OFFSET takes 5 values: OFFSET(reference,rows,cols,height,width) height and width are optional In the reference position you have LARGE(B34:M34,2). This returns a VALUE and is not a reference. I think what you want is this: =LARGE(OFFSET(B34:M34,-33,1,1),2) Michael J

Hey Thanks for taking the time... Hmmm... I have 10 columns each with a header in row 1. at row 34 all the numbers for each column are summed up. I was using "LARGE" to find the largest value in row 34. Once the largest value for that row is found I want the header for that column to be returned to the cell. That is my dilemma... I have been struggling with it now for hours... Scott

Bryco would be the one to answer this one. :) Soylent Green is PEOPLE!!!

Hmmm... Bryco? Scott

I too was looking for the same thing back in January but found nothing. The closest I can find is Flexible Find & Replace Utility which is an Excel Add-in. It will not return the cell value but will find the needed cell's location. It is meant for replacing data or other stuff but it works good to locate data in a large array. You can click on the found item to "Go to" the searched for value on the sheet or sheets. One does not need to use it's Replace feature. I realize that is not what you are looking for but maybe an alternative to what I can not find. HTH Bryan

Sub lgnumber() For col = 1 To 10 celamt = Cells(34, col).Value If celamt > lgnumb Then lgnumb = celamt Heading = Cells(1, col) End If Next col For I = 1 To 10 If lgnumb = Cells(34, I).Value Then Cells(35, I) = Heading End If Next I End Sub Macro: Will find the largest value in row 34 (columns A-J). Then place the heading from the column where largest value was found, in the row beneath that value. If you want the heading to replace the highest cell value, change Cells(35, I) to Cells(34. I).