Index formula question

[TravelMI]

Hi all,

I am trying top use the Index formula to populate a column using matched data from another column. However, the column I wish for the data to be added has merged cells so cannot work out how to find the data from a specific location and then add it to any one of the merged cells.

Below is an example of what I am trying to do. The Number & Text1 columns show how the match should be on the Number columns and this then adds the value in the Text2 column to the Text1. I hope that makes sense?

Any help would be greatly appreciated!

Number1	Text1		Number2	Text2
1	A		1	A
2			2	B
3			3	C
4			4

<tbody>
</tbody>

 

[Special-K99]

It's impossible to tell what cells are merged from that diagram.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.