Not sure that I really understand how your worksheet is set up but am I
correct in assuming that where you are looking up the prices you have 3
columns for the prices, $A, $US and $NZ. If so, you could insert a column
(Hide it if necessary) and use vlookup to insert a number beside the country
code. You can then reference that cell for the Col_index_number in vlookup.

If my assumption is not correct then maybe you can post some more sampling
of your lookup table/s.

--
Regards,

OssieMac


"dragons_lair" wrote:

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.