VLookup with Zeros

[jlc62]

99-111	TECHNICAL REPORT:	$0	$0.00
99-112	ENGINEERING:	$0	$0.00
99-113	PATCH ENGINEERING:	$150	$1.00
99-114	LAND ENGINEERING:	$0	$0.00
99-115	ELEC ENGINEERING:	$300	$1.30
99-116	MECH ENGINEERING:	$25	$3.30

<tbody>
</tbody>

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