I have data formatted like so.
1, 2, 3, 4, null, null, null
A, B, C, D, null, null, null
1, null, null, 4, 5, 6, 7
A, null, null, D, 8, 9, 10
I want to copy the data from row three into the missing "null" cells in row one, because there is a match on cell values one and four upon comparing row one and row three.
So far I have the following.
=INDEX(A2:AE346, MATCH(A351&F351&G351, A2:A346&F2:F346&G2:G346, 0), 2)
Here is a spreadsheet with some sample data so you can test your formulas.