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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,223,900
Messages
6,175,276
Members
452,629
Latest member
SahilPolekar

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