Thank you for your time. I need a vlookup formula that says the following:
If, in workbook x, column C you see any of the words in this workbook cell D2, AND you also see a number that matches the number in cell G2 of this workbook, then please put the number in cell G2 into cell H2.
Example
P.C. Clark Supply 13.12 If it see's any of the words (P.C., Clark, or Supply) in the other workbook column C AND if it sees the exact number 13.12 in column B of that other workbook, then put 13.12 right here.
My reason:
I can't simply do a vlookup, because, in my other workbook, i may have several of the same number. So, if I vlokup $250, it may return that it saw it, but it could be for another supplier. But if I match the name of the company AND the dollar amount, then I have a more unique information to vlookup. But the other workbook (from a bank statement) might word the transaction different than my system. I might call it "P.C. Clark Supply". But the bank statement might show (P.C. Clark Industrial Supply Novi, Michigan 24u58) or something. I totally made that up, but you see my point.
Thank you again.
If, in workbook x, column C you see any of the words in this workbook cell D2, AND you also see a number that matches the number in cell G2 of this workbook, then please put the number in cell G2 into cell H2.
Example
P.C. Clark Supply 13.12 If it see's any of the words (P.C., Clark, or Supply) in the other workbook column C AND if it sees the exact number 13.12 in column B of that other workbook, then put 13.12 right here.
My reason:
I can't simply do a vlookup, because, in my other workbook, i may have several of the same number. So, if I vlokup $250, it may return that it saw it, but it could be for another supplier. But if I match the name of the company AND the dollar amount, then I have a more unique information to vlookup. But the other workbook (from a bank statement) might word the transaction different than my system. I might call it "P.C. Clark Supply". But the bank statement might show (P.C. Clark Industrial Supply Novi, Michigan 24u58) or something. I totally made that up, but you see my point.
Thank you again.
