Excel: excel magic trick 778, example 6


Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples) - YouTube example 6. I have a table similar to this one without the descending numbers as "pipe size". My "pipe sizes" would have to be 0-2, 2.1-4, 4.1-6, 6.1-8, and >8.1. My rainfall would also have to be ranges 0-1000, 1000-2000, 2000- 3000, 3000-4000, and 4000-5000. The corresponding table values are......

1000 2000 3000 4000 5000
2 10 7 5 4 1
4 7 5 4 3 1
6 5 4 3 2 1
8 4 3 2 2 1
100 1 1 1 1 1
What value do I need to put in the 100 spot to show anything greater than 8? if c51=5 and c52=2650 I would need c53=3 and I'm currently getting 5 with... =INDEX(Sheet2!$G$5:$K$9,MATCH(Schaurer!C51,Sheet2!$F$5:$F$9,1),MATCH(Schaurer!C52,Sheet2!$G$4:$K$4,1))


This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of December 16, 2013.


For more resources for Microsoft Excel