I have a list in column A (A1:A10) of various numbers, and a list in column B
(B1:B10). I need a function that outputs the number in column B that is in
the same row as the smallest number in column A. I don't want to sort the
list.

Also I would also like to know how to output the cell reference of the
smallest number in the list.

Example:
A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23
B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98
C1 - 21
D1 - A3

Your First Question: =INDEX(B1:B10,MATCH(MIN(A1:A10),A1:A10,0))
Your Second Question: ="A"&MATCH(MIN(A1:A10),A1:A10,0)

--
Regards,
Dave


"Sloth" wrote:

I have a list in column A (A1:A10) of various numbers, and a list in column B
(B1:B10). I need a function that outputs the number in column B that is in
the same row as the smallest number in column A. I don't want to sort the
list.

Also I would also like to know how to output the cell reference of the
smallest number in the list.

Example:
A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23
B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98
C1 - 21
D1 - A3

Thanks. What if I wanted to find the reference of the smallest cell in an
array?

Example:

A2:A4 - 25, 13, 64
B2:B4 - 53, 26, 98
C2:C4 - 46, 10, 32

A1 - C3

"David Billigmeier" wrote:

Your First Question: =INDEX(B1:B10,MATCH(MIN(A1:A10),A1:A10,0))
Your Second Question: ="A"&MATCH(MIN(A1:A10),A1:A10,0)

--
Regards,
Dave


"Sloth" wrote:

I have a list in column A (A1:A10) of various numbers, and a list in column B
(B1:B10). I need a function that outputs the number in column B that is in
the same row as the smallest number in column A. I don't want to sort the
list.

Also I would also like to know how to output the cell reference of the
smallest number in the list.

Example:
A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23
B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98
C1 - 21
D1 - A3