Matching formula that is too hard for me!

bran987

New Member
Joined
Jan 10, 2005
Messages
45
Hi everyone,

Here are the things that are in each column.

Column A - Phone Numbers
Column B - Dates
Column C - Dates
Column D - Record ID's
Column E - BLANK
Column F - Dates
Column G - Phone Numbers

I'm trying to write a matching or lookup formula that looks up and down these columns and does this:

If A MATCHES G
and F is ON or BETWEEN B and C
then return the value in column D into column E

I really appreciate you guys you've helped me so much over the years.
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,703
Office Version
2007
Platform
Windows
Try this

Code:
=IF(AND(A2=G2,B2<=F2,C2>=F2),D2,"")
 

bran987

New Member
Joined
Jan 10, 2005
Messages
45
Hi DanteAmor,

Thank you, I guess I wasn't totally clear. The phone numbers in columns A and G could be on totally different rows, so I'm trying to make it so it looks all the way up and down both of columns A and G to find matches before it does the rest of the formula.

If I knew how to post a screenshot for you I promise I would! Does that make sense?
 

bran987

New Member
Joined
Jan 10, 2005
Messages
45
Is there a thread that teaches me how to post an example so you can see it? I don't think I was being clear enough.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,608
Office Version
365
Platform
Windows
Is this what you want

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">AL1 1HB</td><td style="text-align: right;;">01/01/2019</td><td style="text-align: right;;">01/02/2019</td><td style=";">d2</td><td style=";"></td><td style="text-align: right;;">11/01/2019</td><td style=";">AL5 5AX</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">AL1 1WB</td><td style="text-align: right;;">02/01/2019</td><td style="text-align: right;;">02/02/2019</td><td style=";">d3</td><td style=";"></td><td style="text-align: right;;">12/01/2019</td><td style=";">AL5 4NG</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">AL1 2NF</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">03/02/2019</td><td style=";">d4</td><td style=";"></td><td style="text-align: right;;">13/01/2019</td><td style=";">AL5 3QA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">AL1 4HF</td><td style="text-align: right;;">04/01/2019</td><td style="text-align: right;;">04/02/2019</td><td style=";">d5</td><td style=";"></td><td style="text-align: right;;">14/01/2019</td><td style=";">AL5 2UR</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">AL1 5JW</td><td style="text-align: right;;">05/01/2019</td><td style="text-align: right;;">05/02/2019</td><td style=";">d6</td><td style=";">d26</td><td style="text-align: right;;">15/01/2019</td><td style=";">AL5 2GX</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">AL10 0PY</td><td style="text-align: right;;">06/01/2019</td><td style="text-align: right;;">06/02/2019</td><td style=";">d7</td><td style=";">d25</td><td style="text-align: right;;">16/01/2019</td><td style=";">AL5 1QE</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">AL10 1DJ</td><td style="text-align: right;;">07/01/2019</td><td style="text-align: right;;">07/02/2019</td><td style=";">d8</td><td style=";">d24</td><td style="text-align: right;;">17/01/2019</td><td style=";">AL4 9YZ</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">AL10 8LG</td><td style="text-align: right;;">08/01/2019</td><td style="text-align: right;;">08/02/2019</td><td style=";">d9</td><td style=";">d23</td><td style="text-align: right;;">18/01/2019</td><td style=";">AL4 9NH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">AL10 9NE</td><td style="text-align: right;;">09/01/2019</td><td style="text-align: right;;">09/02/2019</td><td style=";">d10</td><td style=";">d22</td><td style="text-align: right;;">19/01/2019</td><td style=";">AL4 8WD</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">AL2 1AU</td><td style="text-align: right;;">10/01/2019</td><td style="text-align: right;;">10/02/2019</td><td style=";">d11</td><td style=";">d21</td><td style="text-align: right;;">20/01/2019</td><td style=";">AL4 8EG</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">AL2 2ES</td><td style="text-align: right;;">11/01/2019</td><td style="text-align: right;;">11/02/2019</td><td style=";">d12</td><td style=";">d20</td><td style="text-align: right;;">21/01/2019</td><td style=";">AL4 0SP</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style=";">AL2 3PT</td><td style="text-align: right;;">12/01/2019</td><td style="text-align: right;;">12/02/2019</td><td style=";">d13</td><td style=";">d19</td><td style="text-align: right;;">22/01/2019</td><td style=";">AL4 0EL</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style=";">AL3 4AT</td><td style="text-align: right;;">13/01/2019</td><td style="text-align: right;;">13/02/2019</td><td style=";">d14</td><td style=";">d18</td><td style="text-align: right;;">23/01/2019</td><td style=";">AL3 8JR</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style=";">AL3 5LE</td><td style="text-align: right;;">14/01/2019</td><td style="text-align: right;;">14/02/2019</td><td style=";">d15</td><td style=";">d17</td><td style="text-align: right;;">24/01/2019</td><td style=";">AL3 7NS</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">AL3 6RJ</td><td style="text-align: right;;">15/01/2019</td><td style="text-align: right;;">15/02/2019</td><td style=";">d16</td><td style=";">d16</td><td style="text-align: right;;">25/01/2019</td><td style=";">AL3 6RJ</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">AL3 7NS</td><td style="text-align: right;;">16/01/2019</td><td style="text-align: right;;">16/02/2019</td><td style=";">d17</td><td style=";">d15</td><td style="text-align: right;;">26/01/2019</td><td style=";">AL3 5LE</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style=";">AL3 8JR</td><td style="text-align: right;;">17/01/2019</td><td style="text-align: right;;">17/02/2019</td><td style=";">d18</td><td style=";">d14</td><td style="text-align: right;;">27/01/2019</td><td style=";">AL3 4AT</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style=";">AL4 0EL</td><td style="text-align: right;;">18/01/2019</td><td style="text-align: right;;">18/02/2019</td><td style=";">d19</td><td style=";">d13</td><td style="text-align: right;;">28/01/2019</td><td style=";">AL2 3PT</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style=";">AL4 0SP</td><td style="text-align: right;;">19/01/2019</td><td style="text-align: right;;">19/02/2019</td><td style=";">d20</td><td style=";">d12</td><td style="text-align: right;;">29/01/2019</td><td style=";">AL2 2ES</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style=";">AL4 8EG</td><td style="text-align: right;;">20/01/2019</td><td style="text-align: right;;">20/02/2019</td><td style=";">d21</td><td style=";">d11</td><td style="text-align: right;;">30/01/2019</td><td style=";">AL2 1AU</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style=";">AL4 8WD</td><td style="text-align: right;;">21/01/2019</td><td style="text-align: right;;">21/02/2019</td><td style=";">d22</td><td style=";"></td><td style="text-align: right;;">31/01/2019</td><td style=";">AL10 9NE</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style=";">AL4 9NH</td><td style="text-align: right;;">22/01/2019</td><td style="text-align: right;;">22/02/2019</td><td style=";">d23</td><td style=";"></td><td style="text-align: right;;">01/02/2019</td><td style=";">AL10 8LG</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style=";">AL4 9YZ</td><td style="text-align: right;;">23/01/2019</td><td style="text-align: right;;">23/02/2019</td><td style=";">d24</td><td style=";"></td><td style="text-align: right;;">02/02/2019</td><td style=";">AL10 1DJ</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style=";">AL5 1QE</td><td style="text-align: right;;">24/01/2019</td><td style="text-align: right;;">24/02/2019</td><td style=";">d25</td><td style=";"></td><td style="text-align: right;;">03/02/2019</td><td style=";">AL10 0PY</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style=";">AL5 2GX</td><td style="text-align: right;;">25/01/2019</td><td style="text-align: right;;">25/02/2019</td><td style=";">d26</td><td style=";"></td><td style="text-align: right;;">04/02/2019</td><td style=";">AL1 5JW</td></tr></tbody></table><p style="width:2.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">TB1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">{=IFERROR(<font color="Blue">INDEX(<font color="Red">$D$2:$D$30,MATCH(<font color="Green">1,(<font color="Purple">$G$2:$G$30=A2</font>)*(<font color="Purple">$F$2:$F$30>=B2</font>)*(<font color="Purple">$F$2:$F$30<=C2</font>),0</font>)</font>),""</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 

bran987

New Member
Joined
Jan 10, 2005
Messages
45
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Phone Number</td><td style=";">Date</td><td style=";">Date</td><td style=";">Record ID</td><td style=";">Result</td><td style=";">Date</td><td style=";">Phone Number</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">214-986-7777</td><td style="text-align: right;;">12/30/2019</td><td style="text-align: right;;">1/5/2020</td><td style="text-align: right;;">100</td><td style="text-align: right;;"></td><td style="text-align: right;;">1/3/2020</td><td style=";">214-986-7777</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">214-976-5555</td><td style="text-align: right;;">12/30/2019</td><td style="text-align: right;;">1/5/2020</td><td style="text-align: right;;">200</td><td style="text-align: right;;">300</td><td style="text-align: right;;">1/7/2020</td><td style=";">214-765-0989</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">214-765-0989</td><td style="text-align: right;;">1/6/2020</td><td style="text-align: right;;">1/13/2020</td><td style="text-align: right;;">300</td><td style="text-align: right;;"></td><td style="text-align: right;;">5/2/2019</td><td style=";">214-986-7777</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">214-473-0909</td><td style="text-align: right;;">1/6/2020</td><td style="text-align: right;;">1/13/2020</td><td style="text-align: right;;">400</td><td style="text-align: right;;">500</td><td style="text-align: right;;">1/9/2020</td><td style=";">214-473-0909</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">214-473-0909</td><td style="text-align: right;;">1/6/2020</td><td style="text-align: right;;">1/13/2020</td><td style="text-align: right;;">500</td><td style="text-align: right;;"></td><td style="text-align: right;;">1/2/2020</td><td style=";">214-986-7777</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br />

I figured out how to post in HTML! See how the phone number in G5 matches the phone number in A6, and because the date in F5 is between the dates in B6 and C6, it returns the value in D6 up into E5?
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,703
Office Version
2007
Platform
Windows
ABCDEFG
1Phone NumberDateDateRecord IDResultDatePhone Number
2214-986-777712/30/20191/5/20201001/3/2020214-986-7777
3214-976-555512/30/20191/5/20202003001/7/2020214-765-0989
4214-765-09891/6/20201/13/20203005/2/2019214-986-7777
5214-473-09091/6/20201/13/20204005001/9/2020214-473-0909
6214-473-09091/6/20201/13/20205001/2/2020214-986-7777

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1



I figured out how to post in HTML! See how the phone number in G5 matches the phone number in A6, and because the date in F5 is between the dates in B6 and C6, it returns the value in D6 up into E5?

try this


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:98.85px;" /><col style="width:106.46px;" /><col style="width:103.6px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:143.52px;" /><col style="width:134.02px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PHONE</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">ID</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">RESULT</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PHONE</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >214-986-7777</td><td style="text-align:right; ">30/dic/2019</td><td style="text-align:right; ">05/ene/2020</td><td style="text-align:right; ">100</td><td > </td><td style="text-align:right; ">03/ene/2020</td><td >214-986-7777</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >214-976-5555</td><td style="text-align:right; ">30/dic/2019</td><td style="text-align:right; ">05/ene/2020</td><td style="text-align:right; ">200</td><td style="text-align:right; ">300</td><td style="text-align:right; ">07/ene/2020</td><td >214-765-0989</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >214-765-0989</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">300</td><td > </td><td style="text-align:right; ">02/may/2019</td><td >214-986-7777</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >214-473-0909</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">400</td><td style="text-align:right; ">500</td><td style="text-align:right; ">09/ene/2020</td><td >214-473-0909</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >214-473-0909</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">500</td><td > </td><td style="text-align:right; ">02/ene/2020</td><td >214-986-7777</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E2</td><td >=IFERROR(INDEX($D$3:$D$7,SUMPRODUCT((A3:$A$7=G2)*(B3:$B$7<=F2)*(C3:$C$7>=F2)*(ROW(D3:$D$7)))-2),"")</td></tr></table></td></tr></table>
 

bran987

New Member
Joined
Jan 10, 2005
Messages
45
try this


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:98.85px;" /><col style="width:106.46px;" /><col style="width:103.6px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:143.52px;" /><col style="width:134.02px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PHONE</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">ID</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">RESULT</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">DATES</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PHONE</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >214-986-7777</td><td style="text-align:right; ">30/dic/2019</td><td style="text-align:right; ">05/ene/2020</td><td style="text-align:right; ">100</td><td > </td><td style="text-align:right; ">03/ene/2020</td><td >214-986-7777</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >214-976-5555</td><td style="text-align:right; ">30/dic/2019</td><td style="text-align:right; ">05/ene/2020</td><td style="text-align:right; ">200</td><td style="text-align:right; ">300</td><td style="text-align:right; ">07/ene/2020</td><td >214-765-0989</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >214-765-0989</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">300</td><td > </td><td style="text-align:right; ">02/may/2019</td><td >214-986-7777</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >214-473-0909</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">400</td><td style="text-align:right; ">500</td><td style="text-align:right; ">09/ene/2020</td><td >214-473-0909</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >214-473-0909</td><td style="text-align:right; ">06/ene/2020</td><td style="text-align:right; ">13/ene/2020</td><td style="text-align:right; ">500</td><td > </td><td style="text-align:right; ">02/ene/2020</td><td >214-986-7777</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E2</td><td >=IFERROR(INDEX($D$3:$D$7,SUMPRODUCT((A3:$A$7=G2)*(B3:$B$7<=F2)*(C3:$C$7>=F2)*(ROW(D3:$D$7)))-2),"")</td></tr></table></td></tr></table>

Thanks Dante! I had to add some $'s, change all the 3's in the formulas to 2's, and it ended up being -1 that worked on the ROW part instead of -2 (don't know why) but now it works!!!!!!!!
Many thanks!
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,703
Office Version
2007
Platform
Windows
Thanks Dante! I had to add some $'s, change all the 3's in the formulas to 2's, and it ended up being -1 that worked on the ROW part instead of -2 (don't know why) but now it works!!!!!!!!
Many thanks!
The formula starts at E2, but it should only be checked at E3 down.
The E6 formula will only revise the E7. According to the logic after E6 there is nothing that can go up.

The important thing is that now it works for you.
It was a pleasure to help you.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,006
Messages
5,465,962
Members
406,457
Latest member
Pinky Rose Jordan

This Week's Hot Topics

Top