Hello,
I have an excel sheet of products. I've created a dropdown but what I want now is whenever from the dropdown I select a product, it's price is fetched from another tab and also expenses of that from another sheet. I'm attaching a screenshot which will make it easier to understand.
I have an excel sheet of products. I've created a dropdown but what I want now is whenever from the dropdown I select a product, it's price is fetched from another tab and also expenses of that from another sheet. I'm attaching a screenshot which will make it easier to understand.
| PRICES ZIANA.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 2 | |||||
| 3 | Product | ||||
| 4 | Valentino HD 30" 5*5 Closure | ||||
| 5 | |||||
| 6 | |||||
| 7 | Hair & Lace Price: | ||||
| 8 | Costs per wig: | ||||
| 9 | Shipping fees: | ||||
| 10 | Paypal fees: | ||||
| 11 | Shopify fees: | ||||
| 12 | |||||
Sheet2 | |||||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| B4 | List | =Sheet1!$A$6:$A$109 |
