Moving rows using address and match

[Tenspeed39355]

Good morning guys. I am having a problem getting the rows to move using the following. =ADDRESS(2,MATCH(A2, A2:H2,0)+2,4)
There is no problem in getting the correct ADDRESS or MATCH. I have learned to use the +2 to get the correct cell. The problem is I have a number of rows. After I get the correct cell and row I do a pull down to get the next column and row. The cell will come up correctly but the row will stay the same. Example. B2,C2, H2. I should be seeing the following
B2,C3,H4. What am I doing wrong? I also see that when I do a pull down
all the number change to the corosponding row except the 2 before the MATCH command. Thanks for you time with this
Max

[mdmackillop]

Hi Max
try
=ADDRESS(2,MATCH(A2, A$2:H$2,0)+2,4)
This uses the cell in column A as the search value but retains row 2 as the range to be searched.
Regards
MD

[Tenspeed39355]

Hi I am going to try to send you the ss for you to look at.
Is it posable to have the number come out as I have in the ss?
I think this is the easy way for you to see the problem.
Max

[Tenspeed39355]

I think I sent the attachment. Let me know if you did not get it.
Max

[mdmackillop]

=ADDRESS(ROW(),MATCH(D5,E5:H5,0)+4,4)