Hi,
I have a problem with the creation of a formula for the following setup:
Column C: Inventory 2
Column A: Inventory 1
Column B: Available
Column D: Result
I would need a formula which takes the SKU's in Column C (Inventory 2) and looks for a SKU with which has the same combination of Letters in Column A. If parts of the SKU (same Letters/Characters) are found in Column A, the Number in Column B (Available) corresponding to Column A would need to be displayed in Column D (Result).
Since there are more SKU's in Column A than Column C, I can't just to an ascending sort. I have been provided with a working VLookup formula for my initial post which was related to exactly the same SKU's. But now I would need a solution where the result will be displayed when only parts of a SKU are matching.
Thanks in advance for your help.
Bookmarks