shooting_girl
New Member
- Joined
- Nov 7, 2005
- Messages
- 1
Hi..
I wanted to know the formula for looking up a specific no in a range.
For ex: I want to find 20 when i have 3 ranges, 0-45, 45-90, 90-110 and i want excel to lookup 20 in the 0-45 range. Any idea if this is possible?
Thanks a lot for your co-operation and time..
I wanted to know the formula for looking up a specific no in a range.
For ex: I want to find 20 when i have 3 ranges, 0-45, 45-90, 90-110 and i want excel to lookup 20 in the 0-45 range. Any idea if this is possible?
Thanks a lot for your co-operation and time..