The result of index and match formula is wrong

freyafan

I have a material number and material description in the source sheet which I want to use match & index formula to identify the material description in another sheet, I use this formula:

INDEX({Test Item Database Range 4}, MATCH([PCX Supplied Material#]@row, {Test Item Database Range 2}))

However, the result starts to going wrong from 3rd row, snapshot of the destination and source sheet as below, pls help to check and advice, thank you~

Source Sheet

Destination Sheet

Beth Fantozzi 1

Could this be solved by adding the "search type" (typically 0) in the formula? I've seen instances of my formulas not working correctly when I miss this. In your case, adding in the 0 would look like this:

=INDEX({Test Item Database Range 4}, MATCH([PCX Supplied Material#]@row, {Test Item Database Range 2},0))

Does this help?