hlookup under merged cells

I have cells in Row 4 merged in pairs. That is, N4:O4 are merged into 1 cell, P4:Q4 are merged into 1 cell, R4:S4 are merged into 1 cell, etc, and there are 55 such pairs up to DR4:DS4.

Cells in Row 7 are not merged in pairs.

I would like some way of doing a HLOOKUP across the 55 merged cells in Row 4 and return both values in the corresponding cells in Row 7 underneath the matching cell Row 4.

I hope this makes sense.

I am using Excel 2007 and will need idiot proof instructions about how to implement a VBA solution if this is the only possible way of doing what I need.

Thanks in advance for your consideration of my question. The other teachers and secretaries at my school will never know how much of a help you will have been!

I'm strongly opposed to merging cells, and expect you could (and should) use Center across selection instead.

That said, the HLOOKUP will work, provided you're looking for an exact match in the top row, and retrieving the value of the cell below the left cell in the merged pair.

I'll have a play with Centre Across Selection, but in the mean time, I need both left and right cells. (I got the left cell, but can't get the right).

use index match to match a1
ist number
=INDEX(N4:DS7,4,MATCH(A1,N4:DS4,0))
second number
=INDEX(N4:DS7,4,MATCH(A1,N4:DS4,0)+1)

Thankyou