How to determine the value?

[Eric]

Does anyone have any suggestions on how to determine the value?
Under column A, there is a list of number, and under column B, there is a
list of marks. Some marks will be missing, which can be ignored.
I would like to determine the marks for the minimum number under column A.
In following case, it should return 30% in cell C1, because 2 is the minimum
number with marks.
Does anyone have any suggestions?
Thank anyone very much for any suggestions
Eric

1
2 30%
3 40%
4
5 60%

 

[Max]

In C1, array-entered (CSE): =MIN(IF(A1:A10<>"",A1:A10))
CSE = press CTRL+SHIFT+ENTER to confirm the formula

 

[Eric]

Hi Max:
The score is on the B column, and it should return the score based on the
minimum number under A column. The return score should be 30% for number 2,
because the score for number 1 is null, and should be ignore.
Do you have any suggestions?
Thank you for any suggestions
Eric

 

[Max]

Probably this then ..
In C1, array-entered (CSE):
=INDEX(B1:B10,MATCH(MIN(IF(B1:B10<>"",A1:A10)),IF(B1:B10<>"",A1:A10),0))
Format C1 as perentage