Hi Julie,

So your example was a bit misleading!
I don't think you'll get your requirement done with standard Excel
functions; you probably need a User Defined Function.
To get that right please tell us what to return if values do not fall within
a range and what if ranges overlap.
Maybe it helps if you tell us what the underlying requirement is.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"JulieD" wrote in message
...
Oh, and i can't use VLOOKUP as the data in LOW can't be sorted into
ascending order


"JulieD" wrote in message
...
Hi All

can't quite figure out what formula to use
if i have the number 27.568 in a cell
and i have a table in sheet2 with the following structure
CODE......LOW.....HIGH
A.......26.258.......26.358
B.......27.259........27.359
C.......27.566........27.666

how do i lookup the 27.568 and return the C (as it falls within this
range) - additionally, sometimes the value i'm looking up might match
either a LOW or HIGH and then the associated code needs to be returned.

Cheers
JulieD