Using match

[Guest]

I have the following table

sheets
hits 5 10 15
1 a b c
2 d e f
3 g h i


hits 3
sheets 7

I want to this match to output of "h"
How do I do this?

oldjay

 

[T. Valko]

Since you seem to want the next higher sheet number when the value is
between an interval you need to reverse the order of your table:

Screencap:

http://img165.imageshack.us/img165/7803/lookupkh0.jpg

Biff

 

[Guest]

Thanks

Since you seem to want the next higher sheet number when the value is
between an interval you need to reverse the order of your table:

Screencap:

http://img165.imageshack.us/img165/7803/lookupkh0.jpg

Biff

 

[T. Valko]

You're welcome!

Biff
Microsoft Excel MVP

Thanks