display cell value using a constant column but a changing row value

[Papa Hog]

I am using Excel 2003



I have columns A to P and rows 1 to 225. The values in each row of Column P change constantly. All cells contain numbers

I have a cell P230 with formula =MATCH(MAX(P2:P225),P:P,0) that determines the row that has the highest value in column P

example P230 would have a value of 114

I want to show the value of other columns in the row of the contents of P230, using the value or the Formula in P230

I cannot use =O114 because the row that has the highest value in column P changes all the time.

I'm looking for =O114 to be like O & P230 or =O & MATCH(MAX(P2:P225),P:P,0)


Than I'll want the value of column O, row value P230 plus 26 example =O & P230+26 or =O & MATCH(MAX(P2:P225),P:P,0)+26

[FDibbins]

Hi, welcome to the forum

Maybe this...
=INDEX(A:P,MATCH(MAX(P2:P225),P:P,0),insert-column-number-here)

Or, if you have column headings, we can use another MATCH to find the column number

[Papa Hog]

Hi, welcome to the forum

Maybe this...
=INDEX(A:P,MATCH(MAX(P2:P225),P:P,0),insert-column-number-here)

Or, if you have column headings, we can use another MATCH to find the column number

I put =INDEX(A:P,MATCH(MAX(P2:P225),P:P,0), 15) and it works, thank you

[FDibbins]

Awesome, glad it worked for you