Hi
I have an excel sheet where on Tab A I will have a drop down menu on column C (Products). This drop down menu will list all the fields from TAB B( Company name)
When I select TEST 1 on TAB A in column C I want the Product description from TAB B to populate in the column C. Is this possible??
TAB A
TAB B
I have an excel sheet where on Tab A I will have a drop down menu on column C (Products). This drop down menu will list all the fields from TAB B( Company name)
When I select TEST 1 on TAB A in column C I want the Product description from TAB B to populate in the column C. Is this possible??
TAB A
Company | SKU | Products |
Company 1 | Test2 |
TAB B
Company Name | Product Description | Producy SKU |
Test 1 | Corner Sofa | ABCD-123-ABC |
Test 2 | 2 Seater Sofa Velvet Blue | APR-ABB-BLU |