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)

Col P	Col Q	Col R	Col S	Col T	Col U	Col V	Col W	Col X	Col Y
1	2	3	4	5	6	7	8	9	10
PO LOOKUP!!	Note	R/E # based on PO#	R/E based on Text	Remaining		Non ITG/Not in logs			R/E
4509141680									0
4509141680									0
4509141680									20004286
4509141680									20004286

<tbody>
</tbody>

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!!!!