First match only using DGET

[Dhussar]

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"

 

[IML]

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

 

[Dhussar]

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