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)) .">
Most valuable professional
  • 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))

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel