Lookup with Random Data

P

PFH

Hi;

I am trying to find a formula to do something. Basically, Lookup is th
right formula, except that it wants data in the lookup vector to be i
ascending or descending order, while my data is random.
I have a table with column A being the date of the month, (1,2,3-31).
The next five columns are random numerical data, e.g. 1205, 987 ,345
1287, 876, etc. What I need to do is find the minimum value in eac
column (columns B-F) and display the date from column A that each valu
corresponds to at the bottom of each column.

Thank you,
any help will be greatly appreciate
 
D

Domenic

B32, copied across:

=INDEX($A$1:$A$31,MATCH(MIN(B1:B31),B1:B31,0))

Note that if there is more than one value in a column equalled to th
minimum value for that column, the formula will only return the firs
occurance.

Hope this helps
 
Top