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.)

 

[thewiseguy]

Yes I am seeing that now. Is there a way to not have any spaces? The purpose of the VSTACK formula was supposed to be to combine all 3 worksheets.

 

[Fluff]

You would need to filter the result of the vstack to remove the blanks.

 

[thewiseguy]

Any chance you can sho wme how to do that?

=VSTACK('Product (BOM)'!A2#,'Material (BOM)'!A2#,'Rental (BOM)'!A2#)

 

[Fluff]

Try

=let(v,VSTACK('Product (BOM)'!A2#,'Material (BOM)'!A2#,'Rental (BOM)'!A2#),filter(v,v<>""))

 

[thewiseguy]

awesome, thank you as usual!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[thewiseguy]

Hi - I made some adjustments to my workbook and I need to change/add to this formula. I am trying to amend it, like this but I am getting an error.

=let(v,VSTACK('Fixtures (BOM)'!A3#,'Lamps (BOM)'!A3#,'Accessories1 (BOM)'!A3#), 'Accessories2 (BOM)'!A3#), 'Material (BOM)'!A3#), 'Rental (BOM)'!A3#), filter(v,v<>""))

any ideas??

 

[Fluff]

You have too many ) in there. Remove the ones after the 3rd, 4th & 5th ranges.

 

[thewiseguy]

i did that but it then gives me a prompt to update the values in "Accessories2 (BOM). What causes this in the sheet? What should I be looking for to correct?

 

[Fluff]

Sounds like the sheet does not exist in that workbook. Check the spelling, including spaces.