View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default 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