I tried to find a simple answer to my question, but everything I found seems to be somewhat different from what I need. I have a worksheet showing payroll for each employee, and how much they worked each day of each week. Cell A of each row is the Week Ending date, followed by alternating hours worked and items processed each day of the week for Monday through Saturday. In cell Q of each row is a running total of the employee's wages for that week. Then, on every other line (U51 in my example), the value in cell U is a running total of the employee's wages for that pay period. This system is continued down the sheet, pay period after pay period. The '*' in cell R51 merely signifies that that week is a pay week.
In another part of the sheet (see my second image), I have shown the max and min values for the employee's list of biweekly payroll amounts. That much is easy.
What I want to do is, next to the values shown for the max and min payroll amounts, list the value in cell A for the row shown in the max or min cells. For example, if the employee's highest paycheck is in cell U51, I want to show the value in cell A51 next to the cell for the max value.
In another part of the sheet (see my second image), I have shown the max and min values for the employee's list of biweekly payroll amounts. That much is easy.
What I want to do is, next to the values shown for the max and min payroll amounts, list the value in cell A for the row shown in the max or min cells. For example, if the employee's highest paycheck is in cell U51, I want to show the value in cell A51 next to the cell for the max value.