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
|