Thanks Narayan!
Before I try it again, I do have a quick question.
Since my information is in two different worksheets, do I need to insert another worksheet in one of them so that way my information is all in one workbook or should it work they I have them now?
Thanks!
Chris
Hi Luke,
I tried the formula you gave me....first off thank you....I got farther than I have in a week trying to figure this out. However, all matches came back as not found (and I know there are several items that are in both areas (spreadsheets). I tried the formula in both sheets and got...
Hi! I am needing help trying to find a formula that will help me match the popular description in one spreadsheet to the universal description in another spreadsheet using either the Item ID or Mfg Item ID. My goal is to be able to match as many popular descriptions to the universal...