| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data values | Excel Worksheet Functions | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| How do you get the values of the data between data points | Excel Worksheet Functions | |||
| why do I get the multiple data values when there is no data in my. | Excel Worksheet Functions | |||
| If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions | |||
Threaded Mode
