VLookup with Zeros

[jlc62]

[TABLE="width: 545"]
<tbody>[TR]
[TD]99-111[/TD]
[TD]TECHNICAL REPORT:[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]99-112[/TD]
[TD]ENGINEERING:[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]99-113[/TD]
[TD] PATCH ENGINEERING:[/TD]
[TD="align: right"]$150[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD]99-114[/TD]
[TD]LAND ENGINEERING:[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]99-115[/TD]
[TD]ELEC ENGINEERING:[/TD]
[TD="align: right"]$300[/TD]
[TD="align: right"]$1.30[/TD]
[/TR]
[TR]
[TD]99-116[/TD]
[TD]MECH ENGINEERING:[/TD]
[TD="align: right"]$25[/TD]
[TD="align: right"]$3.30[/TD]
[/TR]
</tbody>[/TABLE]

I am trying to create a report (table) that will look at the table above and only list those items with numbers greater than $0 in the third col (C)?

 

[Joe4]

Welcome to the Board!

I would recommend using Filters, and Filter out anything less than or equal to zero.

 

[jlc62]

I have done that but the data is on tab1 and the report should be on tab2 for instance.

 

[SawdustCollector]

If you are ok with helper cells, you could place this formula in column E after your input table (assuming your table has headers and data starts in row 2) and copy down.

=IF(C2>0,(MAX($E$1:E1)+1),0)

Then enter this formula in B2 of tab2 and copy over and down

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROW()-1,Sheet1!$E:$E,0)),"-")

You will have to change Sheet1 to whatever your sheet is actually named and adjust other cell references as needed.

 

[Joe4]

You can use Advanced Filters to filter the results to a new location.
See: http://www.contextures.com/xladvfilter01.html#videodiffsheet