Forum

Notifications
Clear all

Lookup based on 2 criteria and using a range

3 Posts
2 Users
0 Reactions
140 Views
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

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)

 
Posted : 25/02/2022 1:26 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 25/02/2022 8:31 pm
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

Mynda,

Sorry for the delay, was out of town for my birthday.  Your answer worked perfectly.  Thanks so much!!!!

 
Posted : 04/03/2022 4:49 pm
Share: