Results 1 to 6 of 6

Lookup with comparing values ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-21-2007
    Posts
    118

    Lookup with comparing values ? _RESOLVED_

    I have a table with two columns. The second column has numbers.

    I am trying to do a lookup that will check to see which number after my lookup value is +3 bigger.

    example

    a 11
    b 5
    c 5
    d 6
    e 10
    f 9

    I am looking up "b". I want to return "e" because (a) it is under b in the sequence and (b) 10-5>=3. Is there a way to do this with lookup? I checked the forum but couldn't find anything about lookup and difference in values.

    Thank you in advance.

    Kostas
    Last edited by kostas; 10-24-2007 at 09:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1