I am using and INDEX/MATCH formula to look up the vendor from a products purchased report and match it with products from a product sold report. The vendor data I am looking up begins with a letter(ex. TH10) I have no problem pulling in one vendor of a product. The problem is that some...