I have 2 sheets:

sheet1 contains 2 columns as follows:

```
columnA columnB
AB Texas
BC California
DE Virginia
```

sheet2 contains 1 columns as follows:

```
columnA
AB_documentOne.pdf
BC_documentTwo.pdf
DE_documentThree.pdf
AB_documentFour.pdf
AB_documentFive.pdf
DE_documentSix.pdf
```

In adjacent column "columnB" in sheet2, I would to extract the correct values from columnB in sheet1.

Desired result:

```
columnA columnB
AB_documentOne.pdf Texas
BC_documentTwo.pdf California
DE_documentThree.pdf Virginia
AB_documentFour.pdf Texas
AB_documentFive.pdf Texas
DE_documentSix.pdf Virginia
```

I tried:

```
=INDEX(sheet1!B:B,MATCH(sheet1!A:A,sheet2!A:A,0))
```

Since I am using columnA from sheet1 as a substring lookup for columnA in sheet2, this will produce an error.

Excel version: 2013

Thanks for your help.