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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,278
Messages
5,657,822
Members
418,414
Latest member
ECMdusty

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
Top