matching table to ????

J

jlutz

New Member
Joined
Jun 18, 2011
Messages
29
Hi everyone,
My first post and I could use a little help with this problem.
What I want to do is to select a "package letter" from "personnel packages table and have the personnel fields populate, based on the letter selected. There are 7 package letters in total but again, I want the fields to populate by placing "A" in the box and all of "A" is automatically populated in the column below. If "C" is desired, then the package "C" would then populate the column below. I thought I had it with IF and VLOOKUP but something isn't quite right. Any suggestions would be GREATLY APPRECIATED!!!

<TABLE style="WIDTH: 195pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=258><COLGROUP><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" span=3 width=42><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 99pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl70 height=21 width=132>PACKAGE LETTER</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl70 width=42>a</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl70 width=42></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl70 width=42></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=20>PERSONNEL</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Job Superintendent</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=20>Foreman</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Welders</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 height=20>Laborers</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=20>Hvy equip operator</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Trackhoe operator</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Quality control mgr</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>B pressure welder</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Apprentice</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></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=xl67 height=21>Lead hand</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></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=xl67 height=21>Pipefitter</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 15pt" 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=xl67 height=20>Pipefitter's helper</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 270pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=361><COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" span=4 width=43><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" span=3 width=32><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 70pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl74 height=21 width=93>Personnel packages</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=43>A</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=43>B</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=43>C</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=43>D</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=32>E</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=32>F</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl73 width=32>G</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=20>Job Superintendent</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>6</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: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=21>Foreman</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</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: #f0f0f0" class=xl69 height=21>Welders</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>9</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl71 height=20>Laborers</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>20</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl69 height=20>Hvy equip operator</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>12</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>Trackhoe operator</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>8</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>Quality control mgr</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>B pressure welder</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>9</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>Apprentice</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>9</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>Lead hand</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>6</TD></TR><TR style="HEIGHT: 15pt" 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: #f0f0f0" class=xl69 height=20>Pipefitter</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>5</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl71 height=21>Pipefitter's helper</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>5</TD></TR></TBODY></TABLE>
 
Sort by date Sort by votes
Ok,

Your references that you have in the formula are incorrect.

I have tried replicating your spreedsheet.
Excel Workbook
ABCDEFGHIJ
2PACKAGE LETTERega
3PERSONNELat $/hr/day# DAYSsub-totalLEGEND
4Job Superintendent561$ 105.000$0$/Hour
5Foreman562$ 60.000$0$/DAY
6Welders793$ 120.000$0$/M
7Laborers152010$ 40.000$0
8Hvy equip operator10126$ 49.000$0DAYS
9Trackhoe operator682$ 49.000$00
10Quality control mgr221$ 65.000$0
11B pressure welder794$ 120.000$0METERS
12Apprentice793$ 50.000$00
13Lead hand461$ 45.000$0
14Pipefitter551$ 60.000$0
15Pipefitter's helper551$ 40.000$0
Sheet1
Excel 2007
Cell Formulas
RangeFormula
B4=IF(ISNA(INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B5=IF(ISNA(INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B6=IF(ISNA(INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B7=IF(ISNA(INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B8=IF(ISNA(INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B9=IF(ISNA(INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B10=IF(ISNA(INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B11=IF(ISNA(INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B12=IF(ISNA(INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B13=IF(ISNA(INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B14=IF(ISNA(INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
B15=IF(ISNA(INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(B$2,$N$15:$T$15,0)))
C4=IF(ISNA(INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C5=IF(ISNA(INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C6=IF(ISNA(INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C7=IF(ISNA(INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C8=IF(ISNA(INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C9=IF(ISNA(INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C10=IF(ISNA(INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C11=IF(ISNA(INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C12=IF(ISNA(INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C13=IF(ISNA(INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C14=IF(ISNA(INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
C15=IF(ISNA(INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(C$2,$N$15:$T$15,0)))
D4=IF(ISNA(INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D5=IF(ISNA(INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D6=IF(ISNA(INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D7=IF(ISNA(INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D8=IF(ISNA(INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D9=IF(ISNA(INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D10=IF(ISNA(INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D11=IF(ISNA(INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D12=IF(ISNA(INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D13=IF(ISNA(INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D14=IF(ISNA(INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
D15=IF(ISNA(INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(D$2,$N$15:$T$15,0)))
E4=IF(ISNA(INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A4,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E5=IF(ISNA(INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A5,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E6=IF(ISNA(INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A6,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E7=IF(ISNA(INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A7,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E8=IF(ISNA(INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A8,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E9=IF(ISNA(INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A9,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E10=IF(ISNA(INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A10,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E11=IF(ISNA(INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A11,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E12=IF(ISNA(INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A12,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E13=IF(ISNA(INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A13,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E14=IF(ISNA(INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A14,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
E15=IF(ISNA(INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0))),"",INDEX($N$16:$T$27,MATCH($A15,$M$16:$M$27,0),MATCH(E$2,$N$15:$T$15,0)))
Excel Workbook
MNOPQRST
15Personnel packagesABCDEFG
16Job Superintendent1234566
17Foreman2345566
18Welders3456789
19Laborers10111213151720
20Hvy equip operator6789101112
21Trackhoe operator2345678
22Quality control mgr1112222
23B pressure welder4566789
24Apprentice3466789
25Lead hand1223456
26Pipefitter1234555
27Pipefitter's helper1234555
Sheet1
Excel 2007

If I haven't copied your sheet exactly and your tables start in different cells you will need to adjust the formula accordingly. Or let me know where they start and I can do it.

/Comfy.
 
Upvote 0

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I copied and pasted your first formula listed (b4) and it didn't work. I'm trying to work through the formula with the color codes and tweek it.
Obviously this is an index and match situation and I haven't figured out the formula areas for my application. Once again, I want to select A through G for my package selection, and the field will populate the corresponding values for that selection only.
I may have to select G only. Or C,A,B. Or any other combination for that matter. I have only designed 4 columns for selections. I may have to increase that but for now, the 4 is sufficient.
 
Upvote 0
The formulas that I have pasted have absolute references so when you paste them into your workbook the references will be wrong.

You will need to change them for it to work.

In my previous post I tried to recreate your spreadsheet layout so that the formulas listed have the right references.

Is this not the Case?

On your worksheet where you have entered e g and a next to "Package Letter" Which cell is the e in?

Also for the personnel packages table that lists a to g. Which cell is the a in?

Rather than paste each formula from my previous post separately you can just copy the B4 formula and copy it down to B15.

/Comfy
 
Upvote 0
The small case "e" is B4.
The Personnel Packages table heading, "A" through "G" is M14:S14

I am trying to tweek to get the formula to line up to my worksheet.
 
Upvote 0
Comfy,
The formula works if I select "A" only. I want to be able to select any letter, A through G and have those corresponding results populate the field beneath that letter selected.

I tried editing by adding the the selection of "B" to your formula, and I end up with the #N/A. Then, as expected, when I select "C" through "G", I came up with the same #N/A. But inputting the "A" and again, the formula worked.

I've tried to be clear in what I am trying to accomplish with this "program". But I think the above finally does get what I've been TRYING to say across to you.

Again, I say thank you for your help!
 
Upvote 0
If your result is #N/A your using the wrong formula. Have you read my previous posts? Also as previously posted you would have had to change some of the references. Even though you pasted the data from you worksheet in your posts you did not give any references so I did not know whether the data started in Cell B1 or Z1.

I have again amended the sheet I mocked up to include the correct cell addresses.

Your B6 formula which I hope is the first cell for Job Superintendent will read:

Code: 
=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))

This formula will return:
Excel Workbook
ABCDEFGHIJ
4PACKAGE LETTERega
5PERSONNELat $/hr/day# DAYSsub-totalLEGEND
6Job Superintendent561$ 105.000$0$/Hour
7Foreman562$ 60.000$0$/DAY
8Welders793$ 120.000$0$/M
9Laborers152010$ 40.000$0
10Hvy equip operator10126$ 49.000$0DAYS
11Trackhoe operator682$ 49.000$00
12Quality control mgr221$ 65.000$0
13B pressure welder794$ 120.000$0METERS
14Apprentice793$ 50.000$00
15Lead hand461$ 45.000$0
16Pipefitter551$ 60.000$0
17Pipefitter's helper551$ 40.000$0
Sheet1
Excel 2007
Cell Formulas
RangeFormula
B6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B16=IF(ISNA(INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
B17=IF(ISNA(INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(B$4,$M$14:$S$14,0)))
C6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C16=IF(ISNA(INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
C17=IF(ISNA(INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(C$4,$M$14:$S$14,0)))
D6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D16=IF(ISNA(INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
D17=IF(ISNA(INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(D$4,$M$14:$S$14,0)))
E6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E16=IF(ISNA(INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A16,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))
E17=IF(ISNA(INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A17,$L$15:$L$26,0),MATCH(E$4,$M$14:$S$14,0)))




Please look at using the addin I suggested. It helps users on the forum understand not just your question but also your worksheet layout.
 
Last edited:
Upvote 0
Comfy,
Don't ask me how I did this but I gave you the incorrect info regarding the cell reference for "e". It is B2 and not B4! My humblest apologies! None-the-less, I attempted to edit the formula listed above by amending the reference for B4 (Superintendent) but that amendment still did not produce a working formula for me.
I trust with this post of correct information for you that this will produce what we're looking for! :)
Jerry
 
Upvote 0
Excel Workbook
ABCDEFGHIJ
2PACKAGE LETTERega
3PERSONNELat $/hr/day# DAYSsub-totalLEGEND
4Job Superintendent561$ 105.000$0$/Hour
5Foreman562$ 60.000$0$/DAY
6Welders793$ 120.000$0$/M
7Laborers152010$ 40.000$0
8Hvy equip operator10126$ 49.000$0DAYS
9Trackhoe operator682$ 49.000$00
10Quality control mgr221$ 65.000$0
11B pressure welder794$ 120.000$0METERS
12Apprentice793$ 50.000$00
13Lead hand461$ 45.000$0
14Pipefitter551$ 60.000$0
15Pipefitter's helper551$ 40.000$0
Sheet1
Excel 2007
Cell Formulas
RangeFormula
B4=IF(ISNA(INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B5=IF(ISNA(INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
B15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(B$2,$M$14:$S$14,0)))
C4=IF(ISNA(INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C5=IF(ISNA(INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
C15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(C$2,$M$14:$S$14,0)))
D4=IF(ISNA(INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D5=IF(ISNA(INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
D15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(D$2,$M$14:$S$14,0)))
E4=IF(ISNA(INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A4,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E5=IF(ISNA(INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A5,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E6=IF(ISNA(INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A6,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E7=IF(ISNA(INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A7,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E8=IF(ISNA(INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A8,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E9=IF(ISNA(INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A9,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E10=IF(ISNA(INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A10,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E11=IF(ISNA(INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A11,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E12=IF(ISNA(INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A12,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E13=IF(ISNA(INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A13,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E14=IF(ISNA(INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A14,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
E15=IF(ISNA(INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0))),"",INDEX($M$15:$S$26,MATCH($A15,$L$15:$L$26,0),MATCH(E$2,$M$14:$S$14,0)))
Excel Workbook
LMNOPQRS
14Personnel packagesABCDEFG
15Job Superintendent1234566
16Foreman2345566
17Welders3456789
18Laborers10111213151720
19Hvy equip operator6789101112
20Trackhoe operator2345678
21Quality control mgr1112222
22B pressure welder4566789
23Apprentice3466789
24Lead hand1223456
25Pipefitter1234555
26Pipefitter's helper1234555
Sheet1
Excel 2007

I'm sorry but I don't know what else I can do. Unless I have completely misunderstood what it is that you are asking.

What I think you want is:

If Package letter is blank the cells next to each personnel type will also be blank.
If there is a letter in the Package cell, the formula will return values from the Personel packages table based on the personnel type and the letter entered.

/Comfy
 
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
613
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps

Forum statistics

Threads
1,224,504
Messages
6,179,144
Members
452,891
Latest member
JUSTOUTOFMYREACH

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