How to return corresponding row number in a table if a value falls within the bounds specified? [closed]
- by Eshwar
Possible Duplicate:
Looking up a value, depending on which set of dates another date falls between
Basically I have an excel table with 3 Columns - Month, Start, Finish - where Start and Finish are lower and upper bounds for transaction numbers and Month is a string.
In another cell I have a transaction number that I want to find the corresponding month for.
e.g.
Jan 01 10
Feb 11 15
And if I want to find 12, I should get Feb out.
(No VB, macros, etc. Please)