First match only using DGET
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: First match only using DGET

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is their a function similar to DGET that returns the value of the first cell that matchs the criteria and ignors following cells.

    For example in the following database:
    A B
    1 0
    2 0
    3 1
    4 0
    5 0
    6 1

    I want to look for "1" in column "B" and get back the value "3" from column "A"

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 15:20, Dhussar wrote:
    Is their a function similar to DGET that returns the value of the first cell that matchs the criteria and ignors following cells.

    For example in the following database:
    A B
    1 0
    2 0
    3 1
    4 0
    5 0
    6 1

    I want to look for "1" in column "B" and get back the value "3" from column "A"
    I don't know if you were specifically looking for a database function, but would
    =INDEX(A1:B6,MATCH(1,B1:B6,0),1)

    meet your needs?

    good luck


  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you that was the most helpful response I have gotten to such a specific problem in my life. Maybe the internet will change our lives

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com