Okay, so you found Name Manager?

Then click on "New", then in Name box type DivA
scope = workbook
Refers to
=INDEX(Sheet1!$B$2:$B$26, MATCH(Test!$A$2, Sheet1!$A$2:$A$26,0)): INDEX(Sheet1!$B$2:$B$26, MATCH(Test!$A$2, Sheet1!$A$2:$A$26))=INDEX(Sheet1!$B$2:$B$26, MATCH(Test!$A$2, Sheet1!$A$2:$A$26,0)): INDEX(Sheet1!$B$2:$B$26, MATCH(Test!$A$2, Sheet1!$A$2:$A$26)

Then "OK"

Does that answer your question.