LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ted Metro
 
Posts: n/a
Default lookup going left based on function

I have a table that looks something like this starting at A1

bob 6
dave 2
mike 8
greg 9
chris 1

I want to find the largest value in column b and find the name associated
with that value.

So I can use large(a1:a5,1) to get the largest value, but I can't integrate
that into the lookup formula to get the name because the data isn't sorted.
I've also tried using the address and offset functions, but I can't get it to
work. This has to be pretty easy.

Any ideas from the Excel gurus?
Ted
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing #N/A response when obtained in Lookup function CochranConsult Excel Worksheet Functions 4 June 26th 06 04:03 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Help with function to add percentage to cell based on checkbox. foxgguy2005 Excel Worksheet Functions 3 June 1st 05 05:52 AM
using a function based on the value of a function Judy Excel Worksheet Functions 5 April 28th 05 09:57 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"