I have a range of cells within a row which I desire to determine the maximum
value. In the row that contains the cell with the maximum value I desire to
retrieve the value of a specific cell within that row. I then want to compare
that value to a cell range in a row on a different worksheet and then return
a value in the adjacent cell of that row.