I'm trying to build a spreadsheet to work out some trends from all sorts of data and am looking for a way to automate this process.

I want to be able to lookup an exact or greater than value as specified by one cell, that is then searched for in a range/column of figures. When this number is found to report where it appeared.

Sorry if my explanation is confusing. I'll try it a different way:

Find next number in range (B1:B50) that is greater than or equal to C1, output which row it first appeared in. i.e. A5, A20?

Thanks.