|
-
Aug 1st, 2008, 11:47 AM
#1
Thread Starter
Frenzied Member
Excel Formula - Number within range..{Resolved, and then some}
So we all know that this would be easy in VBA.
However, what I was thinking of doing for a change is using a VLookUp() in this table I have.
The one thing I would need to do though is see if the number in Cell A is within the number range in the table array.
So you have say the number 32 in cell a and in the table array you have:
20 - 24
25 - 29
30 - 34
35 - 39
40 - 44
45 - 49
50 - 54
55 - 59
60 - 64
Think there's a reliable way to return row 3 with a vlookup-type formula?
Thanks for looking.
Last edited by Spajeoly; Aug 4th, 2008 at 04:52 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|