"Mike H" wrote in message
...
=LOOKUP(10,B2:W2)

it will find the largest number up to 10 and ignore any larger ones.

Not quite. It will only do so if the numbers are in ascending order,
otherwise you may get some other when there is a higher value which is still
lower then 10 further in the series.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk