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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Number1[/TD]
[TD]Text1[/TD]
[TD][/TD]
[TD]Number2[/TD]
[TD]Text2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.