Closed Thread
Results 1 to 2 of 2

Excel 2007 : Difficulties writing a search formula with multiple steps..

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Difficulties writing a search formula with multiple steps..

    its kinda hard to explain but ive writen about what Im trying to find along side the data in the excel document which makes it alot easier to understand. Basically which im trying to do is:

    A formula that can find the same value between an x value and randomized x value ( in two different tables) , then calculate weather the randomized x values y value (( x,y)) is equal to or less than the other x values y value and state weather it is true or falue.

    eg. In two different tables :
    (1, 3.2) (1 point for a line) & ( 1, 18.1) (randomized x and y)
    the formula needs to make a search for the same x values ( in this case finding the two 1 values) ... and identifying the randomized y value is larger than the y value as:
    3.2 < 18.1
    therefore stating it is false for not being larger than the randomized number

    Kindregards and thanks guys

    finding points within a region.xlsx

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Difficulties writing a search formula with multiple steps..

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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