index across multiple tables

[Monica at Plastics]

is it possible to use this layout (they are tables, I couldn't get it to paste that way) and have excel look at all the tables and return the header and amount under the header of that table only if it is greater than zero? The tables are on one tab and the results/totals are on a different tab.

I was able to bring back the correct results on the first table. I can't get it to go past that.

BASE BID CABINETS			UPGRADE TO CLEAR ALDER			UPGRADE TO SHAKER DOOR
CABINET COST	$50.00			CABINET COST	$25.00			CABINET COST	$0.00
25.00%	$12.50			25.00%	$6.25			25.00%	$0.00
CABINET TOTAL	$62.50			CABINET TOTAL	$31.25			CABINET TOTAL	$0.00
TAX 7.75%	$4.84			TAX 7.75%	$2.42			TAX 7.75%	$0.00
DELIVERY	$0.00			DELIVERY	$0.00			DELIVERY	$0.00
INSTALL CABS	$0.00	0		INSTALL CABS	$0.00	0		INSTALL CABS	$0.00
INSTALL TRIM	$0.00	0		INSTALL TRIM	$0.00	0		INSTALL TRIM	$0.00
INSTALL HANDLES	$0.00	0		INSTALL HANDLES	$0.00	0		INSTALL HANDLES	$0.00
INSTALL TOTAL	$0.00			INSTALL TOTAL	$0.00			INSTALL TOTAL	$0.00
CONTINGENCY	$5.00			CONTINGENCY	$2.50			CONTINGENCY	$0.00
Total Page
TOTAL	$72.34			TOTAL	$36.17			TOTAL	$0.00
TOTAL W/ PULLS	$72.34			TOTAL W/ PULLS	$36.17			TOTAL W/ PULLS	$0.00

<tbody>
</tbody>

AREA	DESCRIPTION	TOTAL
*******	BASE BID CABINETS	72.34
	UPGRADE TO CLEAR ALDER
	UPGRADE TO SHAKER DOOR

<tbody>
</tbody>

 

[XLfriend777]

Hello Monica at Plastics and welcome to the forum! I think what you are asking is possible, if I understand it correctly. We probably need a little bit more information before we can make suggestions. Should the UPGRADE TO CLEAR ALDER = $31.25? What cell is that and where do you want that to show up? Hope this helps get things started.

 

[Monica at Plastics]

You are correct about the upgrades. the amounts are all in that row (26) on my spreadsheet. I need it to list the choices out on a different tab it looks like this but I only want it to list out IF that "total" cell for that table is greater than Zero.

AREA	DESCRIPTION	TOTAL
*******	BASE BID CABINETS	72.34
	UPGRADE TO CLEAR ALDER
	UPGRADE TO SHAKER DOOR
		(72.34)
		(72.34)
		(72.34)
		(72.34)
		(72.34)
		(72.34)
		0.00
******* TOPS	LAMINATE TOPS-WATERFALL EDGE
	STANDARD COLORS	0.00
	PREMIUM COLORS	0.00
	HD/180FX COLORS	0.00
	SINKS ADD TO EACH ABOVE PRICE	0.00
	STONE COUNTERTOPS-SINKS INCLUDED
	BUILDER LINE GRANITE	0.00
	BUILDER LINE QUARTZ	0.00

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[XLfriend777]

Hi Monica at Plastics - You might consider a formula like ->
=if(A1>0,A1,"")

If you place this formula in Cell B1, it will look in Cell A1 and place the value in B1 only if A1 > 0.