Hi Niek

sorry, misleading in that it was in ascending order, but it came with "gaps"
:)

thanks for your input ... its actually a MS Project initated question but i
often think its easier to do the maths in excel than in project. Basically,
the company is using a strange value system to determine priorities of tasks
and they wanted to nominate values for criteria and then return a priority
setting based on these criteria.

after playing around with it a bit more it looks like a vba solution is the
way to go ... there will never be overlapping ranges but there might be gaps
in the ranges and what i guess i was looking for by posting here was to see
if there was some sort of array formula that can be used to lookup between
two columns. (i've not come to grips with what array formulas can & can't be
used for).

i'll play with the vba and post back if i get stuck.

Cheers
JulieD


"Niek Otten" wrote in message
...
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