Need help with VLOOKUP

[Joefried]

thanks for trying to help me

if the lookup Value of my Vlookup is 0. i.e, If the answer of Vlookup is 0 then my formula should search for next lookup_value in my table_array. Is it possible.

Eg.
Table
abc 0
rty 2
asd 0
qwe 12
abc 34
uio 21

so in the above table =VLOOKUP("abc",A:B,2,0) should be 34 and not 0."




Best Regards
Joe

 

[T. Valko]

thanks for trying to help me

if the lookup Value of my Vlookup is 0. i.e, If the answer of Vlookup is 0 then my formula should search for next lookup_value in my table_array. Is it possible.

Eg.
Table
abc 0
rty 2
asd 0
qwe 12
abc 34
uio 21

so in the above table =VLOOKUP("abc",A:B,2,0) should be 34 and not 0."




Best Regards
Joe

Try this array formula**:

=INDEX(B2:B7,MATCH(1,IF(A2:A7="abc",IF(B2:B7<>0,1)),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[Joefried]

this is what i tried and the answer is N/A
please tell me if i did it wrong

=VLOOKUP(A:A,INDEX('Ebay Report'!J:J,MATCH(1,IF('Ebay Report'!C:C=A19,IF('Ebay Report'!J:J<>0,1)),0)),8,FALSE)

 

[T. Valko]

this is what i tried and the answer is N/A
please tell me if i did it wrong

=VLOOKUP(A:A,INDEX('Ebay Report'!J:J,MATCH(1,IF('Ebay Report'!C:C=A19,IF('Ebay Report'!J:J<>0,1)),0)),8,FALSE)

VLOOKUP won't work for this.

Try it like I suggested.

 

[Joefried]

wow thank you so much it worked

 

[T. Valko]

wow thank you so much it worked

You're welcome. Thanks for the feedback!