Lookups

J

jpfuse

New Member
Joined
Jan 19, 2010
Messages
15
I need help with some lookup formulas. Given the following table:

<TABLE style="WIDTH: 859pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1144><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 213pt; mso-width-source: userset; mso-width-alt: 10386" width=284><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 877" width=24><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 35pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=20 width=46></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=284>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>C</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>D</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>E</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=22>F</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>H</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>I</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>J</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=24>K</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>L</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>N</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 width=64>O</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=21 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl105></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl106 colSpan=4>Fault @ 500 kV</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl107 colSpan=4>Fault @ 230 kV</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl108></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1pt solid" class=xl107 colSpan=4>Fault @ 13.8 kV</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=21 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl103>Fault type===> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl65 colSpan=2>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #e0dfe3" class=xl66 colSpan=2>1LG</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 colSpan=2>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #e0dfe3" class=xl66 colSpan=2>1LG</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl69 colSpan=2>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl70 colSpan=2>1LG</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl99 width=284>Transformer End Opened Fault (All Sources In)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl72 width=128 colSpan=2></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl74 width=128 colSpan=2></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl76></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl77 width=128 colSpan=2>4,427</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl79 width=128 colSpan=2>4,420</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81 width=24></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl77 width=128 colSpan=2>1,498</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1pt solid" class=xl77 width=128 colSpan=2>6,556</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=20 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl100 width=284>Bus Fault (All Sources In)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl83 width=128 colSpan=2>1,728</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl85 width=128 colSpan=2>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl86></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl85 width=128 colSpan=2>3,286</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl85 width=128 colSpan=2>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81 width=24></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl85 width=128 colSpan=2>9,546</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 1pt solid" class=xl85 width=128 colSpan=2>6,688</TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=21 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl101 width=284>Bus Fault (N-1 for Maximum Current)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl88 width=128 colSpan=2>1,728</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl90 width=128 colSpan=2>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl86></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl90 width=128 colSpan=2>4,206</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl90 width=128 colSpan=2>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81 width=24></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl90 width=128 colSpan=2>7,777</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 1pt solid" class=xl90 width=128 colSpan=2>1,111</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl104 height=35 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl102>Outage for N-1 Condition</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl93 width=128 colSpan=2>Station 1 - Station 2 777kV L666</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl93 width=128 colSpan=2>Station 3 - Station 4 777kV L999</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl95></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl93 width=128 colSpan=2>Station 5 - Station 6 777kV L222</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl93 width=128 colSpan=2>Station 11 - Station 10 777kV L111</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl95></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl93 width=128 colSpan=2>Station 22 - Station 44 777kV L444</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 96pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl96 width=128 colSpan=2>Station 67 - Station 66 777kV L888</TD></TR></TBODY></TABLE>
I need to lookup the max number in B3:O5, in this case it would be 9546. Then i need to say that this max is a result of "Fault at 13.8kV" which is in cell L1 and i also need to say "3LG" which is in cell L2. And i also need to say "Bus Fault(All Sources In)" from cell A4. Seems like there should be a fairly simple way to lookup each of these items, but my lookup skills are very limited to the vlookup function. Im sure some combinations of index and match can accomplish this task. any help is greatly appreciated.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
This would ordinarily be reasonable straightforward, but it would seem that you have a lot of merged Cells here which, if is the case, could create problems.

Would you be prepared to revise the layout of your data?

Matty
 
Upvote 0
<TABLE style="WIDTH: 751pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=996><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 213pt; mso-width-source: userset; mso-width-alt: 10386" width=284><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" span=2 width=102><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" span=2 width=102><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 877" width=24><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" span=2 width=106><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 35pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=20 width=46> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=284>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=102>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=102>C</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=22>D</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=102>E</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=102>F</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=24>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 width=106>H</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl89 width=106>I</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=21 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl75></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl93>Fault @ 500 kV</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl93>Fault @ 500 kV</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl94>Fault @ 230 kV</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl94>Fault @ 230 kV</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl94>Fault @ 13.8 kV</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl95>Fault @ 13.8 kV</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=21 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl73>Fault type===> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl96>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl82>1LG</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl82>1LG</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl88>3LG</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl87>1LG</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl70 width=284>Transformer End Opened Fault (All Sources In)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 77pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl79 width=102> </TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; WIDTH: 77pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl83 width=102> </TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl67> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl84 width=102>4,427</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl99 width=102>4,420</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl84 width=106>1,498</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 1pt solid" class=xl90 width=106>6,556</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=20 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl71 width=284>Bus Fault (All Sources In)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl80 width=102>1,728</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl97 width=102>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl85 width=102>3,286</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl97 width=102>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl85 width=106>9,546</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl91 width=106>6,688</TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=21 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl72 width=284>Bus Fault (N-1 for Maximum Current)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl81 width=102>1,728</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl98 width=102>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl86 width=102>4,206</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 77pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl98 width=102>1,197</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: gray; WIDTH: 18pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: #e0dfe3" class=xl86 width=106>7,777</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=106>1,111</TD></TR></TBODY></TABLE>

how about that?
 
Upvote 0
<table style="WIDTH: 751pt; BORDER-COLLAPSE: collapse" border="0" cellpadding="0" cellspacing="0" width="996"><colgroup><col style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width="46"><col style="WIDTH: 213pt; mso-width-source: userset; mso-width-alt: 10386" width="284"><col style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" span="2" width="102"><col style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width="22"><col style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" span="2" width="102"><col style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 877" width="24"><col style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" span="2" width="106"></colgroup><tbody><tr style="HEIGHT: 15pt" height="20"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 35pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl74" height="20" width="46">
<table style="width: 751pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="996"><tbody><tr style="height: 15pt;" height="20"><td class="xl74" style="border-width: 0.5pt; border-style: solid; border-color: windowtext; background-color: transparent; width: 35pt; height: 15pt;" height="20" width="46">
</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 213pt;" width="284">A</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 77pt;" width="102">B</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 77pt;" width="102">C</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 17pt;" width="22">D</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 77pt;" width="102">E</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 77pt;" width="102">F</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 18pt;" width="24">G</td><td class="xl77" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 80pt;" width="106">H</td><td class="xl89" style="border-width: 0.5pt 1pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: transparent; width: 80pt;" width="106">I</td></tr><tr style="height: 15.75pt;" height="21"><td class="xl74" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 15.75pt;" align="right" height="21">1</td><td class="xl75" style="border-width: medium medium 1pt; border-style: none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) windowtext; background-color: transparent;">
</td><td class="xl93" style="border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: transparent;">Fault @ 500 kV</td><td class="xl93" style="border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: transparent;">Fault @ 500 kV</td><td class="xl65" style="border-width: medium 0.5pt; border-style: none solid; border-color: rgb(224, 223, 227) windowtext; background-color: gray;">
</td><td class="xl94" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: transparent;">Fault @ 230 kV</td><td class="xl94" style="border-width: medium medium 1pt 0.5pt; border-style: none none solid solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: transparent;">Fault @ 230 kV</td><td class="xl76" style="border-width: medium 0.5pt; border-style: none solid; border-color: rgb(224, 223, 227) windowtext; background-color: gray;">
</td><td class="xl94" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: transparent;">Fault @ 13.8 kV</td><td class="xl95" style="border-width: medium 1pt 1pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent;">Fault @ 13.8 kV</td></tr><tr style="height: 15.75pt;" height="21"><td class="xl74" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 15.75pt;" align="right" height="21">2</td><td class="xl73" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227); background-color: transparent;">Fault type===> </td><td class="xl96" style="border-width: medium 0.5pt 1pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent;">3LG</td><td class="xl82" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227); background-color: transparent;">1LG</td><td class="xl65" style="border-width: medium 0.5pt; border-style: none solid; border-color: rgb(224, 223, 227) windowtext; background-color: gray;">
</td><td class="xl78" style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext windowtext windowtext rgb(224, 223, 227); background-color: transparent;">3LG</td><td class="xl82" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227); background-color: transparent;">1LG</td><td class="xl66" style="border-width: medium 0.5pt; border-style: none solid; border-color: rgb(224, 223, 227) windowtext; background-color: gray;">
</td><td class="xl88" style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">3LG</td><td class="xl87" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext windowtext windowtext rgb(224, 223, 227); background-color: transparent;">1LG</td></tr><tr style="height: 15pt;" height="20"><td class="xl74" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 15pt;" align="right" height="20">3</td><td class="xl70" style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext windowtext windowtext rgb(224, 223, 227); background-color: transparent; width: 213pt;" width="284">Transformer End Opened Fault (All Sources In)</td><td class="xl79" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) windowtext; background-color: gray; width: 77pt;" width="102">
</td><td class="xl83" style="border-width: medium medium medium 0.5pt; border-style: none none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) rgb(224, 223, 227) windowtext; background-color: gray; width: 77pt;" width="102">
</td><td class="xl67" style="border-width: medium medium medium 0.5pt; border-style: none none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) rgb(224, 223, 227) windowtext; background-color: gray;">
</td><td class="xl84" style="border-width: medium medium 0.5pt 0.5pt; border-style: none none solid solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">4,427</td><td class="xl99" style="border-width: medium 0.5pt; border-style: none solid; border-color: windowtext windowtext rgb(224, 223, 227); background-color: rgb(255, 255, 204); width: 77pt;" width="102">4,420</td><td class="xl68" style="border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: rgb(224, 223, 227) windowtext rgb(224, 223, 227) rgb(224, 223, 227); background-color: gray; width: 18pt;" width="24">
</td><td class="xl84" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">1,498</td><td class="xl90" style="border-width: medium 1pt 0.5pt 0.5pt; border-style: none solid solid; border-color: rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">6,556</td></tr><tr style="height: 15pt;" height="20"><td class="xl74" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 15pt;" align="right" height="20">4</td><td class="xl71" style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext windowtext windowtext rgb(224, 223, 227); background-color: transparent; width: 213pt;" width="284">Bus Fault (All Sources In)</td><td class="xl80" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227); background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,728</td><td class="xl97" style="border-width: 0.5pt; border-style: solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,197</td><td class="xl69" style="border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: rgb(224, 223, 227) windowtext rgb(224, 223, 227) rgb(224, 223, 227); background-color: gray;">
</td><td class="xl85" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">3,286</td><td class="xl97" style="border-width: 0.5pt; border-style: solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,197</td><td class="xl68" style="border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: rgb(224, 223, 227) windowtext rgb(224, 223, 227) rgb(224, 223, 227); background-color: gray; width: 18pt;" width="24">
</td><td class="xl85" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">9,546</td><td class="xl91" style="border-width: medium 1pt 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">6,688</td></tr><tr style="height: 15.75pt;" height="21"><td class="xl74" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 15.75pt;" align="right" height="21">5</td><td class="xl72" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext windowtext windowtext rgb(224, 223, 227); background-color: transparent; width: 213pt;" width="284">Bus Fault (N-1 for Maximum Current)</td><td class="xl81" style="border-width: medium medium 1pt; border-style: none none solid; border-color: rgb(224, 223, 227) rgb(224, 223, 227) windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,728</td><td class="xl98" style="border-width: medium 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,197</td><td class="xl69" style="border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: rgb(224, 223, 227) windowtext rgb(224, 223, 227) rgb(224, 223, 227); background-color: gray;">
</td><td class="xl86" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">4,206</td><td class="xl98" style="border-width: medium 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 77pt;" width="102">1,197</td><td class="xl68" style="border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: rgb(224, 223, 227) windowtext rgb(224, 223, 227) rgb(224, 223, 227); background-color: gray; width: 18pt;" width="24">
</td><td class="xl86" style="border-width: medium medium 1pt; border-style: none none solid; border-color: windowtext rgb(224, 223, 227) windowtext windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">7,777</td><td class="xl92" style="border-width: medium 1pt 1pt 0.5pt; border-style: none solid solid; border-color: windowtext; background-color: rgb(255, 255, 204); width: 80pt;" width="106">1,111</td></tr></tbody></table>

how about that?
Click to expand...
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 213pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="284">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="102">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="102">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="22">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="102">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="102">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="24">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl77" width="106">
</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 1pt solid" class="xl89" width="106">
</td></tr></tbody></table>
Perfect. Now try:

Code: 
="Max "&MAX(B3:I5)&" is a result of "&INDEX(B1:I1,SMALL(IF(B3:I5=MAX(B3:I5),COLUMN(B1:I1)-COLUMN(B1)+1),1))&", "&INDEX(B2:I2,SMALL(IF(B3:I5=MAX(B3:I5),COLUMN(B2:I2)-COLUMN(B2)+1),1))&", "&INDEX(A3:A5,SMALL(IF(B3:I5=MAX(B3:I5),ROW(A3:A5)-ROW(A3)+1),1))
Matty
 
Upvote 0
oops...stratch that...... i didnt enter as array formula....i spoke too soon before i looked at it good. works like a charm....very nice formula. Thanks for the help.
 
Upvote 0
not sure what you are trying to do here. this give #VALUE
Click to expand...

Apologies, I should have stated that it needs entering as an array formula.
oops...stratch that...... i didnt enter as array formula....i spoke too soon before i looked at it good. works like a charm....very nice formula. Thanks for the help.
Click to expand...

Glad it worked. Happy to help.

Matty
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
T
  • Question Question
Exporting Cell Range As PNG - Getting A White Border To The Bottom & Right - Why?
2
Replies
16
Views
188
jolivanes
jolivanes
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G

Forum statistics

Threads
1,224,597
Messages
6,179,808
Members
452,944
Latest member
2558216095

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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