How do I fill in data using index, match, etc. in MS Excel?

Posted by MorningHacker on Super User See other posts from Super User or by MorningHacker
Published on 2012-06-03T02:43:03Z Indexed on 2012/06/03 4:43 UTC
Read the original article Hit count: 551

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.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about worksheet-function