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

S

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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

T
  • Question
matching and returning values from different ranges
Replies
1
Views
672
Fluff
Fluff
B
  • Question
How to calculate Year totals from month range without manually doing
Replies
4
Views
319
Fluff
Fluff
A
  • Question
Making the formula Dynamic based on Date Range
Replies
6
Views
2K
apie5
A
J
  • Question
Copying a row from one sheet to another based on Month and Sorted
Replies
6
Views
933
sandy666
sandy666
H
  • Question
Get Nearest value from a range based on a reference cell value
Replies
5
Views
780
hsandeep
H

Forum statistics

Threads
1,215,327
Messages
6,124,280
Members
449,149
Latest member
mwdbActuary

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