Problem with MAX value and associated cells

R

REW2705

I want to search a column of data (D2:D86) and have the search show not that
value but the text in the adjacent C cell. The only what that i can think to
do this is have a if loop that searches each cell to see if it is the max, if
it is it shows the adjacent cell text, if not then it checks the next cell,
but the column has 85 values and will grow, i dont want a cell that has a
function that long. Any suggestions?????


Please Help

Ryan
 
T

tina

sounds like you're working in Excel. suggest you post your question in an
Excel newsgroup. this newsgroup is devoted to MS Access relational database
software.
 
Top