View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
Posts: 57
Default Tool to use to lookup pricing

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