VLOOKUP a value other than the first one

[chendere]

Hi all,

This is my problem:

A1 0
A2 3
A1 1
A2 7
A2 5
A2 2

The col starting with A1 is the identifier and the col starting with 0 is the value I seek.

As you can see there is two A1's, I want the first value it finds that is NOT zero

Any help would be appreciated, Thanks!

[NBVC]

If you table is in A1:B6, then try:

=INDEX(B1:B6,MATCH(1,(A1:A6="A1")*(B1:B6>0),0))

this formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER,...you'll see { } brackets appear around it.

Note: you can replace "A1" with cell reference housing the lookup value.

you must reconfirm formula with CSE keys after any changes to it.