vlookup for only column with values

[bmpreston]

So I'm trying to use a vlookup to check a table of a few values, and only print the numbers if the value is more than zero.

Column A returns the value in Column C IF Column D is at least 1 or higher.

If Column D is zero, Column A skips the Column C value.

I have approx 3000 rows to validate. The copying of the formula is of course quite easy. Just need the base formula.

Thanks in advance.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Blank[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]NEEDED FORMULA (1000)[/TD]
[TD][/TD]
[TD]1000[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Needed formula (1001)[/TD]
[TD][/TD]
[TD]1001[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Needed Formula (1003) (SKIPS 1002)[/TD]
[TD][/TD]
[TD]1002[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Needed Formula (1004)[/TD]
[TD][/TD]
[TD]1003[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Needed Formula (1006) (Skips over 1005)[/TD]
[TD][/TD]
[TD]1004[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Needed Formula (Etc)[/TD]
[TD][/TD]
[TD]1005[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Needed Formula (Etc)[/TD]
[TD][/TD]
[TD]1006[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[bmpreston]

That does provide a value from the U column, but is one value before the row with a value higher than 0.

I get U4 when Z4 is zero, although Z5 is NOT 0

I am hoping to get U5, since Z5 is NOT 0.

Thanks

 

[James006]

In your initial explanation, everything was starting in Row 2 ...

In your actual workbook, everything starts in Row 3 ...

As a consequence, you should keep the consistency ... and make sure to define your Named Range ...starting in Row 3 ...

HTH

 

[bmpreston]

Awesome. I seem to be working. Thanks a bunch. Nothing like late night coding for the boss...

 

[James006]

You are welcome ...

 

[Aladin Akyurek]

In A1 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($C$1:$C$7,SMALL(IF(ISNUMBER($D$1:$D$7),IF($D$1:$D$7>0,ROW($C$1:$C$7)-ROW($C$1)+1)),ROWS($A$1:A1))),"")