Vlookup to plug formula

[Eb0la11]

Hey all, I have a worksheet with a drop down menu in one cell for my user to pick a sink bowl from a list of available sink bowls.

Depending on their selection I'd like to lookup the name they selected into a table and pull a formula from an adjacent column. How can I get the formula to come over.

If they chose Undermount Sink Hi-Macs HM-BLS-1612 I'd like my lookup cell to be "=0,L!Thickness_Countertop),Pnt(-12.75,0,L!Thickness_Countertop),Pnt(-15,-2.25,L!Thickness_Countertop),Pnt(-15,-12.75,L!Thickness_Countertop),Pnt(-12.75,-15,L!Thickness_Countertop),Pnt(12.75,-15,L!Thickness_Countertop),Pnt(15,-12.75,L!Thickness_Countertop),Pnt(15,-2.25,L!Thickness_Countertop),Pnt(12.75,0,L!Thickness_Countertop),Pnt(0,0,L!Thickness_Countertop))"

Here is my lookup table below.

 

[cooleomter]

Hi if you still need this here is my answer it's the same as my past project.
1. you need to create a database of your items. sample

sample1.xlsx
	A	B	C	D	E
1	Sink	Typical Setback	Width	Length	Pine for stone cut out
2	Model 1	3	100	20	100
3	Model 2	5	200	20	30
4	Model 3	25	100	25	25
5
6
7
8
database

2. create a Search sheet on the same workbook.

sample1.xlsx
	A	B	C	D	E	F
1
2		Search Your Sink:
3
4		Typical Setback	Width	Length	Pine for stone cut out
5		0	0	0	0
6
7
8
9
10
Search

Cell Formulas
Range	Formula
B5:E5	B5	=IFERROR(UNIQUE(INDEX(FILTER(database!A:E,database!A:A=Search!C2),SEQUENCE(5),{2,3,4,5}))," ")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
C2:E2	List	=database!$A$2:$A$14

test :

sample1.xlsx
	A	B	C	D	E	F
1
2		Search Your Sink:	Model 2
3
4		Typical Setback	Width	Length	Pine for stone cut out
5		5	200	20	30
6
7
8
9
10
11
Search

Cell Formulas
Range	Formula
B5:E6	B5	=IFERROR(UNIQUE(INDEX(FILTER(database!A:E,database!A:A=Search!C2),SEQUENCE(5),{2,3,4,5}))," ")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
C2:E2	List	=database!$A$2:$A$14

may God bless you