I'm gonna do this right since last time I did it I got told to do it right. (sorry about that)
Anyway, I have a workbook that I've created that lists SKU for all the products that my company has (all variations). There are 3 drop down menus (validation) that when any combination is picked between the 3, the SKU number for that "item" auto populates in the 4th column. If the item doesn't exist, i'd like "DOES NOT EXIST" to auto populate in the 4th column if possible.
I have attached the workbook for better clarification .. I know it involves vlookups and IF rules. Thanks for the help folks!
Bookmarks