Question on how to Match/lookup first then do Product function

[asiaviolet]

Hi All:

I know there is a quicker way to do this then how I think I can do it. How can I do a IF statement to say "IF Column E matched Managed Hosting on top then multiplie Column F x Hosting cost of $490 on top then if column E matched SAN then multiply F x San cost of $140. I don't want to do 5 layers of nesting to build a very long IF statments. Is there a shorter way to do this?



[TABLE="width: 653"]
<tbody>[TR]
[TD][/TD]
[TD]Item[/TD]
[TD]Item[/TD]
[TD]Monthly Cost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Managed Hosting[/TD]
[TD]Hosting[/TD]
[TD] $ 490 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SAN[/TD]
[TD]SAN (tb)[/TD]
[TD] $ 140 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NAS[/TD]
[TD]NAS(tb)[/TD]
[TD] $ 35 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]VM[/TD]
[TD]VM (gb)[/TD]
[TD] $ 8 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]VDI[/TD]
[TD]VDI (gb)[/TD]
[TD] $ 12 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ExportMonth[/TD]
[TD]PixieProjectName[/TD]
[TD]PixieProjectType[/TD]
[TD]LineType[/TD]
[TD]Mthly Unit[/TD]
[TD]Monthly Price[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1/1/2015[/TD]
[TD]AAA[/TD]
[TD]Client[/TD]
[TD]Managed Hosting[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]$3,430 [/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1/1/2015[/TD]
[TD]AARP[/TD]
[TD]Client[/TD]
[TD]Managed Hosting[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]$25,480 [/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1/1/2015[/TD]
[TD]AARP PMAX[/TD]
[TD]Client[/TD]
[TD]Managed Hosting[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]$2,450 [/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1/1/2015[/TD]
[TD]Abbott[/TD]
[TD]Client[/TD]
[TD]Managed Hosting[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$1,960 [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD]MSTR[/TD]
[TD]OG[/TD]
[TD]SAN[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]$354 [/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD]NWF[/TD]
[TD]Client[/TD]
[TD]SAN[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]$26 [/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD]PayPal[/TD]
[TD]Client[/TD]
[TD]SAN[/TD]
[TD="align: right"]3.5[/TD]
[TD="align: right"]$490 [/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD]PayPal Credit[/TD]
[TD]Client[/TD]
[TD]SAN[/TD]
[TD="align: right"]20.0[/TD]
[TD="align: right"]$2,800 [/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD]Product Development[/TD]
[TD]OG[/TD]
[TD]SAN[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]$269 [/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD]INtelliMerge[/TD]
[TD]Product[/TD]
[TD]VM[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"]$2,112 [/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD]IT[/TD]
[TD]OG[/TD]
[TD]VM[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]$704 [/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD]IT[/TD]
[TD]OG[/TD]
[TD]VM[/TD]
[TD="align: right"]2188[/TD]
[TD="align: right"]$17,502 [/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD]IT[/TD]
[TD]OG[/TD]
[TD]VM[/TD]
[TD="align: right"]1462[/TD]
[TD="align: right"]$11,699 [/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD]Kimberly Clark[/TD]
[TD]Client[/TD]
[TD]VM[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$32 [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]

 

[steve the fish]

Yes use a VLOOKUP using the lookup table at the top.

 

[asiaviolet]

Duh! Thanks! I knew there was a quicker WAY.