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.