Thread: displaying adjacent cell when using max/min formulae
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default displaying adjacent cell when using max/min formulae
Hi,

you could use

=VLOOKUP(MAX(A1:A24),A1:B24,2,)

--
Thanks,
Shane Devenshire


"formula428" wrote:

I'm using the max/min formulas to display the appropriate values [say in
column A]. say the maximum is located in cell A20, i'd also like to have
excel display the output of cell B20 in another cell.

how do i do this in Excel 2003?
Reply With QuoteReply With Quote