Hi,
Lets assume you have in sheet2 the information as follows
Column A Product
Column B location
Column C Product

Then in sheet 1 you have your information as follow

in cell A2 = product
in A3 = duration
in A4= location

then to pull the price use

=sumproduct(--(A2=sheet2!$A$1:$A$100),--(A4=sheet2!$B$1:$B$100),$C$1:$C$100)

That will pull the price from sheet2


"H" wrote:

Hi - I need to create a form or tool for users by tomorrow morning to select
from a few choices and then look in another tab for the actual amts

For example they would choose from drop downs for the following questions

Which Price list (they would have 5 choices) USD, Euro, Euro/GBP, Euro/USD,
Japan/Yen

Which Product (2 options) product A, product B

Duration of License (they could choose from 1 month up to 36 months)

Geography ( they could choose 5 options)

Price (this is where it does the calculation)

so in another tab there would be the currencies by product
and in another tab there would be geography and an amt attached to those to
multiple by

Anybody have any ideas? Thank you