On Sep 26, 3:01 pm, bj wrote:
randbetween is not what you want, Randbetween selects a random integer
between two variables
I am not sure what you have but probably a vlookup
=vlookup(A1084,$BG$6:$BM$19,7)
might do most of what you want
I do not know where the BM 24 fits in



"Titus" wrote:
the data in columns BG is depth Interval values ,e.g. 2510 ft 3250 ft
the data in BM is the name related to this depth Interval , e.g.
Mantu, and the data in the A column is the current depth.
what i am trying to do is correlate the current depth (Axxxx) to Depth
Interval(BGxxxx:BGxxxy) and name it accordingly from the list BMxxxx.
so, if the current depth fit in depth interval 1, the name is picked
up from the related list, otherwise i check the next depth interval
and so on.
hope this is clear and thanks for your help in advance.

HTH
Hani
New 2007 user- Hide quoted text -

- Show quoted text -

Vlookup does not work for me, it picks up the closest number and match
the result. this is an attempt to have a value verified between two
values, not the close match.
what i need is a "between" function
Thanks for the suggestion