Vlookup & Custom Cell Formatting Question

ML43s52

New Member
Joined
Jul 22, 2014
Messages
11
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 :laugh:

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.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top