How do I return one value from a range, based on a criterion from a separate range of cells?

stevensimon10482

New Member
Joined
May 3, 2017
Messages
2
Hello!

I am looking at two tables, and I need to return a "salary" (hourly wage) value based on an employee "step" that advances every year. In Table 2 below, in the orange fields, I'm looking to return the proper value, for each person, for the step they advance each year.

So, for example, in Status Quo Wages, in 2018 Abigail Brainard should be making $10.34, an Apple Picker's Step 3 Status Quo Salary.

I need to say, "Based on that year's Column F step in Table 2, xyz person will make the wages in Columns D through O." I've tried a bunch of nested IF functions but haven't quite got there.
<table cellspacing="0" border="0" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody>[TR]
[TD="align: left"][/TD]
[TD="align: left"]
[/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody></table><table cellspacing="0" border="0" width=""><colgroup width="180"></colgroup><colgroup width="127"></colgroup><colgroup span="2" width="80"></colgroup><colgroup width="113"></colgroup><colgroup span="3" width="80"></colgroup><colgroup width="75"></colgroup><colgroup span="10" width="80"></colgroup><tbody> [TR]
[TD="align: left"]TABLE 1[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="colspan: 4, align: center"]Status Quo Salary Scale[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2017[/TD]
[TD="colspan: 4, align: center"]Proposed Salary Scale 2018[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]JobTitle[/TD]
[TD="align: center"]Job Code[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Apple Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]AP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.76 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $10.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.01 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.14 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Berry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]BP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.82 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $11.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.21 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Cherry Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]CP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $12.89 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.27 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Date Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]DP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.13 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.25 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.37 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.49 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $13.95 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Grain Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]GP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $14.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.02 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.15 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.27 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.40 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C5E0B4, align: left"]Loquat Picker[/TD]
[TD="bgcolor: #C5E0B4, align: left"]LP[/TD]
[TD="bgcolor: #C5E0B4, align: left"]
[/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.10 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.22 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.46 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.14 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.26 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.38 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $15.50 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.08 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.21 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.34 [/TD]
[TD="bgcolor: #C5E0B4, align: right"] $16.47 [/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]TABLE 2[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Title[/TD]
[TD="align: center"]Code[/TD]
[TD="align: center"]Base Hourly[/TD]
[TD="align: center"]Hired[/TD]
[TD="align: center"]Step[/TD]
[TD="colspan: 4, align: center"]Step[/TD]
[TD="colspan: 3, align: center"]Status Quo Salary[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2017[/TD]
[TD="colspan: 3, align: center"]Proposed Salary 2018[/TD]
[/TR]
[TR]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Step June 23, 2017[/TD]
[TD="align: center"]Step June 23, 2018[/TD]
[TD="align: center"]Step June 23, 2019[/TD]
[TD="align: center"]Step June 23, 2020[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[TD="align: center"]2019[/TD]
[/TR]
[TR]
[TD="align: left"]Abigail Brainard[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.22[/TD]
[TD="align: right"]8/7/2015[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Christine Davidson[/TD]
[TD="align: left"]Apple Picker[/TD]
[TD="align: center"]AP[/TD]
[TD="align: center"]$10.10[/TD]
[TD="align: right"]8/8/2014[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #FFD966, align: left"]???[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Eloy Flanagan[/TD]
[TD="align: left"]Date Picker[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.34[/TD]
[TD="align: right"]11/29/2002[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Gabriela Harrison[/TD]
[TD="align: left"]Cherry Picker[/TD]
[TD="align: center"]CP[/TD]
[TD="align: center"]$12.34[/TD]
[TD="align: right"]3/24/1989[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Igbert Jollyman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.46[/TD]
[TD="align: right"]5/4/2012[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Klaus Lanniman[/TD]
[TD="align: left"]Grain Picker[/TD]
[TD="align: center"]GP[/TD]
[TD="align: center"]$14.34[/TD]
[TD="align: right"]11/30/2001[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Maribel Nolasco[/TD]
[TD="align: left"]Loquat Picker[/TD]
[TD="align: center"]LP[/TD]
[TD="align: center"]$15.22[/TD]
[TD="align: right"]4/29/1994[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]Orlando Parakeet[/TD]
[TD="align: left"]DP[/TD]
[TD="align: center"]DP[/TD]
[TD="align: center"]$13.46[/TD]
[TD="align: right"]4/29/2016[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[TD="bgcolor: #FFD966, align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
[TR]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[TD="align: left"]
[/TD]
[/TR]
</tbody></table>
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Hi!

A couple of options:

Upload your file to a file sharing website like Dropbox then post the link here. Some people here won't or can't click on links so you may be limiting the amount of responses to your question using this method.

Or:

You can use one of the free tools here that allow you to post screenshots of your workbook.

Regards,

CJ
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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