Hi

i wonder if someone can tell me what function or group of functions i need to look at to achieve the following

i have a list in a range

20
33
45
68
74

i then enter in a cell a value to use as a lookup

example 30

i need to do two things

look up the next largest number available from the range in this case it would be 33 and return that


if i enter 33 and since 33 exists in the list i need it jump to the next largest so returning 45 in this case.

i presume i can use two if statements but dont know the best way to work out the offset of moving to the next largest value and if i should use index and match or vlookup etc.

just looking for a pointer for the best way of doing it and also a bit of explanation of how i can use an offset to select the cell next to it or below it

Thanks a alot