D
dragons_lair
I have a spreadsheet which contains the following
C1 C2 C3 C4
C5 C6 C7
CountryCode, CategoryCode, Product Code, Product Description, $A, $US, $NZ
I am using Data Validation to Select the product code based on the category
code selected, and using VLookup to select the corresponding product
description.
My question is how can I get a price selected based on the CountryCode as
well.
C1 C2 C3 C4
C5 C6 C7
CountryCode, CategoryCode, Product Code, Product Description, $A, $US, $NZ
I am using Data Validation to Select the product code based on the category
code selected, and using VLookup to select the corresponding product
description.
My question is how can I get a price selected based on the CountryCode as
well.