Looking up NON - ZERO numbers, using Formula

[agage5]

Thank you for helping me!

I am trying to do a lookup that will pull the first Non-Zero # in a column. The problem is when I do a vlookup, it pulls the first match, and if that match is blank - that's not what I want. I need the first match that has a number in it.

Cell G33 - Here is where my formula is: - please let me know where I'm going wrong with this formula
=IF('50B Data- 2017'!$Y$10:$Y$3913<>"0",INDEX('50B Data- 2017'!$P$10:$Y$8193,MATCH('2017 - PREPAID'!F33,'50B Data- 2017'!$P$10:$P$8193,0),10))

I was trying to pull only non-zero numbers in row Y (which is #10 columns away from Row P)
I want to match my # in Cell F33 to the number in Col P, and have it pull the first non-zero number in col Y.

For example,

Cell F33 has a value of 4509141680, I want to match that number to Col P, and find the value (non-zero in Col Y (I want it to show 20004286)

Cell F33 = 45091414680, Cell G33 = Need formula that will pull in 20004286 (and not 0)

[TABLE="width: 662"]
<tbody>[TR]
[TD]Col P[/TD]
[TD]Col Q[/TD]
[TD]Col R[/TD]
[TD]Col S[/TD]
[TD]Col T[/TD]
[TD]Col U[/TD]
[TD]Col V[/TD]
[TD]Col W[/TD]
[TD]Col X[/TD]
[TD]Col Y[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]PO LOOKUP!![/TD]
[TD]Note[/TD]
[TD]R/E # based on PO#[/TD]
[TD]R/E based on Text[/TD]
[TD]Remaining[/TD]
[TD][/TD]
[TD]Non ITG/Not in logs[/TD]
[TD][/TD]
[TD][/TD]
[TD]R/E[/TD]
[/TR]
[TR]
[TD]4509141680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4509141680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4509141680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20004286[/TD]
[/TR]
[TR]
[TD]4509141680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20004286[/TD]
[/TR]
</tbody>[/TABLE]



Thank you so much for your help!!

 

[steve the fish]

Re: Looking up NON - ZERO numbers, using Formula - Please Help

See if this works:

=INDEX($Y$2:$Y$10000,MATCH(1,INDEX(($P$2:$P$10000=$F$33)*($Y$2:$Y$10000>0),0),0))

 

[agage5]

Re: Looking up NON - ZERO numbers, using Formula - Please Help

WOW!!!!!!

Steve the Fish!!!!!!!!!!!!!!!!!!!! that is EXACTLY what I needed!! It works perfectly.

Thank you!!!!