Need help with display formula
Posted by paul on November 01, 2000 11:28 AM
I am working with a worksheet that has multiple rows of data that correspond to a value entered in F3. F3 will correspond to a year value in column B. based on that correlation will be an end number value (in column G) in the row of the correlating number of column B. Is there a way I can get the end value to show up in a designated cell based on F3 and the correlating end value?
B2=3, end value G3 = $30,000. How do I get Cell AA1 to display $30,000 based on F3?