Not sure I follow you on this.

Can you post a small example of your data and demonstrate what result you
want?

--
Biff
Microsoft Excel MVP


"DPingger" wrote in message
...
TVal.

I have a similar problem comparing dates.

A1:A20 has the dates that needs to be compared to a range of dates in
C1:D25
and if within range then enter the value in E1:E25 in corresponding Cell
in
column B.

I've tried a simple If statement to no avail.

=If(C1<A1<D1,E1,if(C2<A1<D2,E2........ not working.

Help!!!

TIA

Pingger

"T. Valko" wrote:

I've tried vlookup, but I'm not getting the results I was looking for.

How are we supposed to know what result you're looking for if you don't
tell
us!

Need more detail.

For example:

I want to find the value in A1 that is somewhere in the range L1:L1000
and
when found return the corresponding value from the range M1:M1000. The
data
to be returned is _____. (text, numeric, could be either)

--
Biff
Microsoft Excel MVP


"SMH" wrote in message
...
There are two sets of data with one field matching in both sets. I
want
to
be able to put a formula into a cell and find the matching field,
whether
it
is in cell 10 or cell 1000. I've tried vlookup, but I'm not getting
the
results I was looking for. Any other suggestions.