L
Lori
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.
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.