View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default vlookup and hlookup

I have a pricing table that looks like the following

1 2 3
1 $0.190 $0.190 $0.250
2 $0.190 $0.170 $0.250
3 $0.250 $0.250 $0.250

The numbers 1,2,3 represent from and to calling destinations. I have
drop-down selections below to list the countries and convert to the
appropriate numbers. Then I want to create a formula using both vlookup and
hlookup to show the price. As example, if the call is from 2 and to 2, the
price displayed by this formula would be $0.170.