CONCATENATE not working when table is filtered?

[thewiseguy]

Is there a workaround for when a cells formula is CONCATENATE but then columns are filtered?

You can see the formula of row 2 is actually from row64.

Any help is appreciated!

20200000-Ener.v1 - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Reference	IndoorOutdoor	Category	SubCategory	Voltage	Temp	Mount	Backup	Sensor	MFG	Name
2	Maxlite 9W LED Lamp 2Ft T8 MV 4K	Indoor	Lamp	8Ft T8	MV	4K				Eiko	Maxlite 9W LED Lamp 2Ft T8 MV 4K
Proposed

Cell Formulas
Range	Formula
A2	A2	=[@Name]
K2	K2	=CONCATENATE(Proposed!$J64," ",Proposed!$O64,"W"," ","LED"," ",Proposed!$C64," ",Proposed!$D64," ",Proposed!$E64," ",Proposed!$F64," ",Proposed!$G64," ",Proposed!$H64," ",Proposed!$I64)

 

[Fluff]

Get rid of the sheet name in the formula, you should never use the sheet name of the active sheet.

 

[thewiseguy]

Get rid of the sheet name in the formula, you should never use the sheet name of the active sheet.

worked like a charm. thank you much.

 

[Fluff]

You're welcome & thanks for the feedback.