VSTACK Causing "FALSE"

[thewiseguy]

Hi All - any ideas on what is happening in A4?

BDF.Sau.Ext-08232023.v2023.6 - WIP.xlsm
	A		C	D	E	F	G
1	Mfg/Item		Item Type	Manufacturer	Vendor	Part #	Quantity
2	T1 320W LED Area Light [WS-MCCT]		Fixture	T1 LIGHTING		T1-SALED/MW320-MCCT	13
3	T1 Arm Extension [BR]		Accessory	T1 LIGHTING		AR	13
4	FALSE
5	UNITEDRENTALS Boom, Articulated, 30-39' Diesel Week		Rental	United Rentals		Boom/39ft/Week	1
6
Full BOM (prd.mat.ren.)

 

[Fluff]

any ideas on what is happening in A4?

Without seeing your data. No.

In future please select to show formulas when you create a minisheet, it's a lot easier to see that way.

 

[thewiseguy]

I have the "cell formula" option checked off - it's not giving me the formulas in the output

 

[Fluff]

There should be a tick in that box.
Can you post the data from the other 3 sheets.

 

[thewiseguy]

BDF.Sau.Ext-08232023.v2023.6 - WIP.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Mfg/Item	Item	ApplicationType	Manufacturer	Vendor	Part #	Fix. Qty	Lamp Qty	Unit Cost ($)	Extended Cost	Margin (%)	Unit Price	Extended Price	Notes
2	T1 320W LED Area Light [WS-MCCT]	320W LED Area Light [WS-MCCT]	Area	T1 LIGHTING		T1-SALED/MW320-MCCT	13		$155.00	$2,015.00	30.00%	$221.43	$2,878.57
3	T1 Arm Extension [BR]	Arm Extension [BR]	Accessories	T1 LIGHTING		AR	13		$25.00	$325.00	30.00%	$35.71	$464.29
Product (BOM)

BDF.Sau.Ext-08232023.v2023.6 - WIP.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Mfg/Item	Item	Item Type	Manufacturer	Vendor	Part #	Qty		Unit Cost ($)	Extended Cost	Margin (%)	Unit Price	Extended Price	Notes
2	FALSE
Material (BOM)

BDF.Sau.Ext-08232023.v2023.6 - WIP.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Mfg/Item	Item	ApplicationType	Manufacturer	Vendor	Part #	Qty		Unit Cost ($)	Extended Cost	Margin (%)	Unit Price	Extended Price	Notes
2	UNITEDRENTALS Boom, Articulated, 30-39' Diesel Week	Boom, Articulated, 30-39' Diesel Week	Lift		United Rentals	Boom/39ft/Week	1		$1,500.00	$1,500.00	30.00%	$2,142.86	$2,142.86
3
Rental (BOM)

 

[Fluff]

Thanks for that.
Your getting FALSE in the VSTACK because that's what you've got in the Material sheet.

 

[thewiseguy]

yes sory, I should have qualified that really I am trying to get the "FALSE" in the material sheet to disappear. What is my formula doing that is retruning this value?

 

[Fluff]

Because you have told the filter function to return false if nothing matches the criteria.

 

[thewiseguy]

so replace "FALSE" with "" and should be good?

 

[Fluff]

That's right, but you will get a blank row.