Please see the table below for the cells referenced in my question......
Cell D1 is Data Validation from cells A1:A18
If cell D1 = Cell A2 then I need the value typed into cell E1 to contain the symbol in cell B2 $15
If cell D1 = Cell A7 then I need the value typed into cell E1 to contain the symbol in cell B7 15%
If cell D1 = Cell A9 then I need the value typed into cell E1 to contain the symbol in cell B7 15
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD="align: center"]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service OI %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction OI %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Safety OIR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Agreement Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Agreement Retention[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Sales Productivity[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Technician Productivity[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]GM / MH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Backlog GM %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Gross Margin Fade $[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Customer Engagement[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Employee Engagement[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I've been trying to achieve the results I'm looking for with a combination of custom formatting of cell E1 and Vlookup.
I feel like I'm trying to achieve the impossible, my head hurts from banging it against an Excel wall
Any and all assistance will be greatly appreciated.
Thank you in advance for reading my post, I hope to hear from someone much smarter than me soon.
Cell D1 is Data Validation from cells A1:A18
If cell D1 = Cell A2 then I need the value typed into cell E1 to contain the symbol in cell B2 $15
If cell D1 = Cell A7 then I need the value typed into cell E1 to contain the symbol in cell B7 15%
If cell D1 = Cell A9 then I need the value typed into cell E1 to contain the symbol in cell B7 15
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD="align: center"]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction Revenue Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction OI Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service OI %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Construction OI %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Safety OIR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Agreement Growth[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Service Agreement Retention[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Sales Productivity[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Technician Productivity[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]GM / MH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Backlog GM %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Gross Margin Fade $[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]$[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Customer Engagement[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD]Employee Engagement[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I've been trying to achieve the results I'm looking for with a combination of custom formatting of cell E1 and Vlookup.
I feel like I'm trying to achieve the impossible, my head hurts from banging it against an Excel wall
Any and all assistance will be greatly appreciated.
Thank you in advance for reading my post, I hope to hear from someone much smarter than me soon.