December 4, 2021
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?
July 16, 2010