Thank you for helping me! ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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)
<tbody>
</tbody>
Thank you so much for your help!!
![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Big grin :biggrin: :biggrin:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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!!
Last edited: