Let me start by thanking you for reading this post and offering to help!
In the same file, I have a worksheet populated by a report. On the next worksheet, I pull data to make it easier to read.
I pull the max number from a selection of cells and have the result populate the cell. For instance:
Now, what I would like is for next cell (G3, in this case) to pull the data from the first column & first cell of the Max row. So that if MAX from worksheet Scorecard is F32, it will pull A32 and populate.Cell F3 =MAX(ScoreCard!F20:F33)
Please, note... the Max will not always be on the same row... so tomorrow, MAX may be F23... or F30... In which case I would need to pull A23 or A30
Thanks for the help!
Bookmarks