Results 1 to 24 of 24

Thread: Excel Formula - Number within range..{Resolved, and then some}

Threaded View

  1. #1

    Thread Starter
    Frenzied Member Spajeoly's Avatar
    Join Date
    Mar 2003
    Location
    Utah
    Posts
    1,068

    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
  •  



Click Here to Expand Forum to Full Width