Look at Range of numbers and return the next number higher than x

[gonhikin]

Hi! I'm sure this is an easy one but still not something I've done before so I'd appreciate any assistance.
To keep is simple. in a1:a5 are values 5,10,15,20,25. In c1 value is 13. Need a formula to look at range a1:a5
and return only the next number higher than 13. Of course it's a3 or 15. Thanks again!!!! I'll try to have a more
taxing question in future postings.

[benishiryo]

hi gonhikin, welcome to the forum. try:
=INDEX(A1:A5,MATCH(C1,A1:A5,1)+1)

[daddylonglegs]

If C1 is 15 I assume the formula should return 15? If so try an "array formula" like

=MIN(IF(A1:A5>=C1,A1:A5))

confirmed with CTRL+SHIFT+ENTER

[gonhikin]

Thanks much benishiryo! I shoulda been able to do that one myself but I know help was right here!! THANKS!