Need help arriving at a sum of multiple Vlookups...

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8
Listed are the two tables that I am trying to join using a Vlookup. However, I was wondering if there was a better way to possibly get the same result using array functions in Excel.

<table style="border-collapse: collapse; width: 624pt;" border="0" cellpadding="0" cellspacing="0" width="829"><col style="width: 48pt;" span="5" width="64"> <col style="width: 16pt;" width="21"> <col style="width: 80pt;" span="4" width="106"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" height="20" width="64">Name</td> <td class="xl65" style="width: 48pt;" width="64">Item-1</td> <td class="xl65" style="width: 48pt;" width="64">Item-2</td> <td class="xl65" style="width: 48pt;" width="64">Item-3</td> <td class="xl65" style="width: 48pt;" width="64">Item-4</td> <td class="xl65" style="width: 16pt;" width="21"> </td> <td class="xl65" style="width: 80pt;" width="106">Vlookup-Item-1</td> <td class="xl65" style="width: 80pt;" width="106">Vlookup-Item-2</td> <td class="xl65" style="width: 80pt;" width="106">Vlookup-Item-3</td> <td class="xl65" style="width: 80pt;" width="106">Vlookup-Item-4</td> <td class="xl67" style="width: 48pt;" width="64">Total</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">a</td> <td class="xl66">1</td> <td class="xl66">3</td> <td class="xl66">5</td> <td class="xl66">7</td> <td class="xl66">
</td> <td class="xl66">5</td> <td class="xl66">12</td> <td class="xl66">22</td> <td class="xl66">22</td> <td class="xl67">61</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">b</td> <td class="xl66">2</td> <td class="xl66">4</td> <td class="xl66">6</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">7</td> <td class="xl66">17</td> <td class="xl66">27</td> <td class="xl66">
</td> <td class="xl67">51</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">c</td> <td class="xl66">1</td> <td class="xl66">5</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">5</td> <td class="xl66">22</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl67">27</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">d</td> <td class="xl66">2</td> <td class="xl66">4</td> <td class="xl66">8</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">7</td> <td class="xl66">17</td> <td class="xl66">17</td> <td class="xl66">
</td> <td class="xl67">41</td> </tr> </tbody></table>

<table style="border-collapse: collapse; width: 96pt;" border="0" cellpadding="0" cellspacing="0" width="128"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" height="20" width="64">Item</td> <td class="xl65" style="width: 48pt;" width="64">Price</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">1</td> <td class="xl66">5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">2</td> <td class="xl66">7</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">3</td> <td class="xl66">12</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">4</td> <td class="xl66">17</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">5</td> <td class="xl66">22</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">6</td> <td class="xl66">27</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">7</td> <td class="xl66">22</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8</td> <td class="xl66">17</td> </tr> </tbody></table>
Any insight would be greatly appreciated.

Sudheer
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hello Sudheer & Welcome to the Board!

Can you show which values are the results you expect and explain how they are derived because it wasn't clear to me from your first post - thanks! I suspect some form of SUMPRODUCT/SUMIFS will be appropriate.
 

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8
Hi Richard,

Thx for the quick response.

I want to end up with the Total column without having to do all the different Vlookup's (Vlookup-Item-1 thru Vlookup-Item-4) and summing up the result.

Vlookup is "IF(B2>0,VLOOKUP(B2,$A$10:$B$17,2,FALSE),"")"
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Here's one option:
Excel Workbook
ABCDEFGHIJKL
1NameItem-1Item-2Item-3Item-4Vlookup-Item-1Vlookup-Item-2Vlookup-Item-3Vlookup-Item-4TotalFormula
2a135751222226161
3b246717275151
4c155222727
5d248717174141
6
7ItemPrice
815
927
10312
11417
12522
13627
14722
15817
Sheet3
Excel 2010
Cell Formulas
RangeFormula
L2=SUMPRODUCT(LOOKUP($B2:INDEX($B2:$E2,COUNT($B2:$E2)),$A$8:$B$15))


You can't have a blank in column B and an item filled in Column C ie this won't work:
Excel Workbook
ABCDE
1NameItem-1Item-2Item-3Item-4
2f6
Sheet3
Excel 2010 you'd need to write it as:
Excel Workbook
ABCDE
1NameItem-1Item-2Item-3Item-4
2f6
Sheet3
Excel 2010
 

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8

ADVERTISEMENT

Thank you Richard. I was using something similar {=SUM(LOOKUP(B2:E2,$A$10:$A$18,$B$10:$B$18))} with a dummy table 2 entry to handle blanks - Example Item 99 with price 0.

However, there is a situation both these option fail. i.e if we have an entry in column B thru E of table-1 without a corresponding entry in table-2. Try spacing out Item 4 and the answer with both the solutions will be 46 while the vlookup will return a "NA".

Is there any way to handle such cases without having to separately check that values entered in column B thru E of table-1 have a corresponding entry in Table-2.

Again, thank you very much.

Sudheer
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Sudheer, how about this one:
Excel Workbook
ABCDEFG
1NameItem-1Item-2Item-3Item-4Formula
2f627
3b04644
4c175827
5d24841
6
7ItemPrice
815
927
10312
11417
12522
13627
14722
15817
Sheet3
Excel 2010
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
 

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8

ADVERTISEMENT

Richard...thx again.

The Vlookup method outlined in my first message would have indicated that '0' in row-3 of table -1 and '58' in row-4 of table-2 do not have a corresponding entry in Table-2 with a "#NA" in the result.

In this solution, I am not notified of that fact and hence may result in an incorrect calculation. The result for row-3 and row-4 should probably be 44+something and 27+something and I would like the formula to indicate to me that there is probably a missing entry.

May be I am expecting to do too much with excel formulas and I may have to use VBA instead or add another column for the check.

Thx again for your insights.

Sudheer

Sudheer, how about this one:
Excel Workbook
ABCDEFG
1NameItem-1Item-2Item-3Item-4Formula
2f627
3b0[/B]4644
4c175827
5d24841
6
7ItemPrice
815
927
10312
11417
12522
13627
14722
15817
Sheet3
Excel 2010
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself
 

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8
Attached is the sample with the various options...My problem is with the result when one of the value in Col B through E of table-1 does not have a corresponding entry in table-2. Check the results when you delete Item-4 from table-2. I would like to be informed that an entry is missing in table-2 like the result in the "Total" column of table-1.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 14">****** name="Originator" content="Microsoft Word 14"><link rel="File-List" href="file:///C:%5CUsers%5CModenaF1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><link rel="themeData" href="file:///C:%5CUsers%5CModenaF1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CModenaF1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 768pt; margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="1024"> <tbody><tr style="height: 15pt;"> <td colspan="2" style="width: 96pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="128">
Table 1<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
Name<o:p></o:p>
</td> <td style="width: 50.45pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
Item-1<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Item-2<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Item-3<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Item-4<o:p></o:p>
</td> <td style="width: 16pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21">
<o:p></o:p>
</td> <td style="width: 80pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
Vlookup-Item-1<o:p></o:p>
</td> <td style="width: 80pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
Vlookup-Item-2<o:p></o:p>
</td> <td style="width: 80pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
Vlookup-Item-3<o:p></o:p>
</td> <td style="width: 80pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
Vlookup-Item-4<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(146, 208, 80); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Total<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Option 1<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Option 2<o:p></o:p>
</td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
Option 3<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
a<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
6<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
27<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(146, 208, 80); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
b<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
0<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
4<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
6<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
#N/A<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
27<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(146, 208, 80); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
#N/A<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
c<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
1<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
5<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
5<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
22<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(146, 208, 80); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
27<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
d<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
2<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
4<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
8<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
7<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
#N/A<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107">
17<o:p></o:p>
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; background: none repeat scroll 0% 0% rgb(146, 208, 80); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
#N/A<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
24<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
24<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
24<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61"></td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61"></td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="width: 96pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="128">
Table 2<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
Item<o:p></o:p>
</td> <td style="width: 50.45pt; background: none repeat scroll 0% 0% rgb(191, 191, 191); padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
Price<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
1<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
5<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
2<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
7<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
3<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
12<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
5<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
22<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
6<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
27<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
7<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
22<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
8<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
17<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
99<o:p></o:p>
</td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67">
0<o:p></o:p>
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> <tr style="height: 15pt;"> <td style="width: 45.55pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61"></td> <td style="width: 50.45pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 16pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="21"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="107"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"></td> </tr> </tbody></table>
Option 1 =SUMPRODUCT(SUMIF($A$11:$A$17,$B3:$E3,$B$11:$B$17))
Option 2 =SUM(SUMIF($A$11:$A$18,B3,$B$11:$B$18),SUMIF($A$11:$A$18,C3,$B$11:$B$18),SUMIF($A$11:$A$18,D3,$B$11:$B$18),SUMIF($A$11:$A$18,E3,$B$11:$B$18))
Option 3 = {=SUM(IF(COUNTIF($A$11:$A$18,$B3:$E3),LOOKUP($B3:$E3,$A$11:$B$18)))}
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Do you mean like in the Formula2 column?
Excel Workbook
ABCDEFGH
1NameItem-1Item-2Item-3Item-4FormulaFormula2
2f62727
3b04644#N/A
4c175827#N/A
5d2484141
6
7ItemPrice
815
927
10312
11417
12522
13627
14722
15817
Sheet3
Excel 2010
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
 

p51mustang

New Member
Joined
Jul 24, 2010
Messages
8
Hi Richard,

That is absolutely what I wanted. Thank you very much for providing me the solution. I really got a good lesson in excel!

Sudheer
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,516
Messages
5,511,765
Members
408,864
Latest member
cmajewsk

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top