+ Reply to Thread
Results 1 to 3 of 3

First Occurring Number Search

  1. #1
    Registered User
    Join Date
    06-26-2017
    Location
    Ny, USA
    MS-Off Ver
    2011
    Posts
    16

    First Occurring Number Search

    Hello All,

    I am trying to build a formula to capture the value in the cells based on the first occurring number from a range in a particular column

    capture122345453.JPG

    In the current example looking for a formula which can search for the first occurring number in the range(1,2) in column E and return the corrsponding values in the other 2 columns test1 and test 2.

    The range can be dynamic. I tried Index, match etc but could not build a working formula.

    Thank You

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: First Occurring Number Search

    Hi yatindatta,

    It is hard to know what you are given in your example above. What are you given (start with) and what should a formula return?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    06-26-2017
    Location
    Ny, USA
    MS-Off Ver
    2011
    Posts
    16

    Re: First Occurring Number Search

    Apology for not being clear. Input is the first two tables and output is the third table. The formula should search the value in column Test1 and based on the search the two cells are copied in the third table. The number to be searched are given in the range table. You can even forget the range table and consider it as a range of numbers which I have considered 1,2 in this case.

    Hope this helps

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for number in column, then search for "number greater than" in adjacent row.
    By Karlss in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-23-2017, 08:22 AM
  2. VBA Code - Search text & search number & search qty and result - Urgent Please
    By naresh73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2014, 10:51 AM
  3. [SOLVED] Finding the number occurring 2nd, 3rd, 4th, 5th most often
    By impact18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2012, 02:42 PM
  4. Saving duplicate entries occurring X number of times
    By vmartyan in forum Excel General
    Replies: 2
    Last Post: 03-15-2012, 12:12 PM
  5. Most Occurring Number
    By styre in forum Excel General
    Replies: 2
    Last Post: 06-13-2009, 02:30 AM
  6. [SOLVED] count number occurring within specific date range
    By Biff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2006, 01:40 PM
  7. count number occurring within specific date range
    By Ducky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2006, 01:35 PM

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