Hey martindwilson ...also Formula Guru...

I was going though the file and I just caught something. Looking at sample 4, why isn't line 227 on "PURCH_HIST_ALBLIVSAL_EXP_072213" not returning line 1649 or 1650 on "ITEM_MASTER_EXTRACT_072213"?

If I understand the formula correctly, it is taking the left 8 characters from the lookup value and returning matches from "ITEM_MASTER_EXTRACT_072213"???