refer to cell based on value

You're welcome.

Jonmo,

Yes, I utilized the lookup function for the first time, grasped the concept, and your solution worked perfectly.

I can now display the "final" profit number that is tabulated on the bottom line of my worksheet at the top of the worksheet and will save me lots of time as I plug in different values at the top and then instantly see the results at the top also, versus the very bottom row.

The first value is equal to over a billion, so the lookup function will default to looking for the next lowest value in column C. Since Column C is acting as a counter, the last column will be the largest number and the last column is selected. Then just plug in the corresponding column as the third value in this equation and, bang, I have my profit number! Perfect! Thanks again!

I meant to say bottom row, not bottom column above! Rookie mistake!

Rookie question. How do I mark a thread "solved"?