Hi,
On the input tab I would like to -
When "CGLS" is selected in AB10 and "SLW2NV" (which is a sku from sku tab in column A) is selected, return "SLW2NV" in A26.
When "CGLP" is selected in AB11 and "PLW2NV" (which is a sku from sku tab in column A) is selected, return "PLW2NV" in A27.
The idea is that when a certian sku is keyed on input tab, and the CGL indicator in column AB is selected, the sku $ itself is returned in a certain cell.
Note - this formula would go in the following ranges: A26:A29, G26:G29, M26:M29, S26:S29.
Thank you!
Bookmarks