Get data between two values
 

Hi,

I have the following data:
1000 2000
Between 2000 3000
1000 2000 10 25
2001 3000 20 30


Anda I have about 6000 rows with this data EX : ROW 1 from 1050 to
2500, ROW 2 from 1050 to 2500

So I would to have a formula that check columns and rows to give 10,
25,20,30 depends the value I put

Did you understand ?

I try with sumproduct, but I'm having some dificulties

thank you

Get data between two values
 

This sounds like a double lookup. If I am right, the function below is what
you need. It will require a little effort on your part, but this should get
you going:
=INDEX(A1:E4,MATCH(G1,A1:A4,0),MATCH(G2,A1:E1,0))

Notice, the values in G1 and G2 are the two values that you are looking for.


Regards,
Ryan--

--
RyGuy


"Carpe Diem" wrote:

Hi,

I have the following data:
1000 2000
Between 2000 3000
1000 2000 10 25
2001 3000 20 30


Anda I have about 6000 rows with this data EX : ROW 1 from 1050 to
2500, ROW 2 from 1050 to 2500

So I would to have a formula that check columns and rows to give 10,
25,20,30 depends the value I put

Did you understand ?

I try with sumproduct, but I'm having some dificulties

thank you