excel problem

[caja-dglh]

Ok, I know a way I can solve this with a hideous nested IF statement, but would really rather have an alternative that doesn't kill the spreadsheet (there is plenty more to be done later that will do that).

I have a value, x. x changes for each of the 2400 rows on the page - lets say it is column A.

I have a range of numbers - 0,7,14,21,30,90

I need to pick up which the largest of the range of numbers is that is less than or equal to x.

I can have the range typed somewhere in a set of cells or whatever. I just need a non-data brutal process that will pick out my number.

[caja-dglh]

excel problem

oh, solved it - hlookup with a true seems to get it.

[David Agnew]

excel problem

Try:

LOOKUP(x,A:A)

(I knew it was one of the lookups, but I tested with 48, and 47 was one of the earliest numbers it came up with)

[caja-dglh]

excel problem

Thanks Phoebe. It is quite dependent on the zero being in the range in my version, but I will take it.