Simplifying a Formula

For these kind of searches it is more useful to create a two-column table where 1st is what you search and 2nd is the result. This will make your formula much smaller (and more efficient) and it would be much easier to update or replace keywords.

If you not sure how to do that here is an example

Assuming text strings are in col A, the search items are in Col D and results in Col E

Enter formula in B2 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B	C	D	E
1	Text string	Formula	Look up table ---->	Search	Results
2	these panels are too big	GRP Hoarding		Panels	GRP Hoarding
3	what we going to do with piles?	Shoring System		Mock Up Sample of GRP Hoarding	GRP Hoarding
4				Piles	Shoring System
5				Removal of Hard Landscaping	Hard Landscaping
6				Project Sign Board	Project Sign Board
7				Removal of Asphalt Pavement	Concrete Pavement
8				Removal of Soft Landscaping	Soft landscaping
9				Directional Signage	Directional Signage
10				Light Fittings	Light Fittings
11				Camera & Speakers	Camera & Speakers
12				DB’s	DB’s
13				Water Leak Test	Water Leak Test
14				Re-routing	Re-routing