need help with VBA or formula to populate cell based on index result

[doodlebug323]

Hi, I'm new to this and I hope I explain this the right way. I've managed to write two index arrays, one to find the first cell with a number and the last cell with a number in a row range and populate each of these to a cell:
range is N5:AR5
1st cell with number populates to F5 per array in F5
last cell with number populates to H5 per array in H5
that part works fine.

Now I need to populate E5 & G5 with the cell in row 4 that corresponds with each the 1st and last cell with numbers from row 5 - example:
1st cell with number that has populated to F5 is AA5, so I need AA4 to populate to E5
last cell with number that has populated to H5 is AG5, so I need AG4 to populate to G5

My spreadsheet has many, many rows, so I need this to apply to all of them, all of them to pull the corresponding info from row 4.

FYI:
AA5=5429
AA4=14
AG5=5429
AG4=20
F5=5429
H5=5429
E5=first day column to be populated
G5=last day column to be populated
[TABLE="width: 2813"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]START[/TD]
[TD]START[/TD]
[TD]FIRST[/TD]
[TD] FIRST[/TD]
[TD]LAST[/TD]
[TD]LAST[/TD]
[TD]TOTAL[/TD]
[TD]TOTAL[/TD]
[TD]HRS/[/TD]
[TD]YTD[/TD]
[TD]YTD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R#[/TD]
[TD]DESCRIPTION[/TD]
[TD]DATE[/TD]
[TD]HOURS[/TD]
[TD]DAY[/TD]
[TD] READING[/TD]
[TD]DAY[/TD]
[TD]READING[/TD]
[TD]DAYS[/TD]
[TD]HRS[/TD]
[TD]DAY[/TD]
[TD]DAYS[/TD]
[TD]HRS[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]30[/TD]
[TD]31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]1/8/14[/TD]
[TD]5326[/TD]
[TD][/TD]
[TD]5429[/TD]
[TD][/TD]
[TD]5429[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5429[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5429[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]2/3/14[/TD]
[TD]3538[/TD]
[TD][/TD]
[TD]3538[/TD]
[TD][/TD]
[TD]3539[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3538[/TD]
[TD]3539[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I apologize if I have not explained this correctly, I appreciate any assistance that can be provided.

Thank you!

 

[doodlebug323]

nevermind, i figured it out