Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    If statements (MS 2003)

    I need to create an embedded if statement
    there's one cell being referenced, but four arguments must be tested....
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If statements (MS 2003)

    See the attached version. I created a small lookup table and used VLOOKUP.
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: If statements (MS 2003)

    Vlookup..didn't know it could be used that way. I always thought an exact match was necessary. Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If statements (MS 2003)

    It depends on whether there is a 4th argument, and if so, what its value is. The formula

    =VLOOKUP(lookup_value, search_range, column_number)

    or

    =VLOOKUP(lookup_value, search_range, column_number, TRUE)

    does a "fuzzy" lookup - it stops at the first value in the first column of search_range that is greater than or equal to lookup_value. The first column of search_range *must* be sorted in ascending order for this to work.

    The formula

    =VLOOKUP(lookup_value, search_range, column_number, FALSE)

    looks for an exact match for lookup_value. The first column of search_range doesn't have to be sorted for this version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •