>
> Ok, can anyone tell me if this can be done:
>
> Say I have a spreadsheet as follows:
>
> Fred Don Ginger
> 1500 1000 500
>
> (for the text representation, row A has names: Fred, Don,
> Ginger; row B has values: 1500, 1000, 500)
>
> Say I want to know the smallest value in row B. I use the
> SMALL() function in Excel to put this in column E. The
> question is, is there a way to determine the name that goes
> with that small amount and put it in row A, column E?
>
> Does this make sense to anyone? Is it doable? One fresh
> apple-cinnamon muffin to whomever can answer this one...
Yes and no
First of all, use MIN() rather than SMALL() since you don't need the
"position" element
Next, you'll need to use HLOOKUP()
The problem is that HLOOKUP looks in the first row of the area for the
element, so row 3 will have to contain a "copy" of row 1 (=A1 etc.)
But, taking that into account
=HLOOKUP(E2,A2:C3,2,FALSE)
E2 contains the MIN()
A2:C3 is the range covering the numbers and the "copies" of the names
2 is the second row
FALSE says that it'll look for it not in order and close
HTH
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
