I cannot seem to figure this out. I have a Word Document that has Section Headers, this information has been transferred to my "Sections" table. Ultimately I need to look at the "Sections List" table and based on the Page and Line Number, determine the Correct Section Header (Column C) that corresponds to the "Sections" table. I thought I had found something, but it does not quite work. Based on the information from. In my Live File The "Sections" contains about 25+ sections, and the "Sections List" normally contains in excess of 500+ records. As you can understand, this is why the ability to use a formula to determine the correct Section Header based on the Page and Line. Attached is is a small sample of the workbook. I was under the impression that this formula would work, but it doesn't. What did I do Wrong?
=IFNA(INDEX(Sections!$C$2:$C$8,MATCH(1,(Sections!$A$2:$A$8=$A2)*(Sections!$B$2:$B$8=$B2),0)),$C1)
Hi Sherry,
Try this in cell C2, then copy down:
=INDEX(Sections!$C$2:$C$8,MATCH('Section List'!A2&'Section List'!B2,Sections!$A$2:$A$8&Sections!$B$2:$B$8,1))
If you don't have Dynamic Arrays then you must enter the formula with CTRL+SHIFT+ENTER.
Mynda
Mynda,
Sorry for the delay, was out of town for my birthday. Your answer worked perfectly. Thanks so much!!!!