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...... 2 4 6 8 100 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)) .">
• Hot Topics

# 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...... 2 4 6 8 100 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))