Label in D3:F3 the 3 DV choices: Post, Courier, Air freight
Then place in B12:
=IF(B13="","",HLOOKUP(B13,D3:F4,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Rod" wrote:
in cell B13 I have a drop down box with 3 options
Post
Courier
Air freight
and I need function that will allow me to have a different answer when each
is selected the out put in B12
eg when Post is selected I wish the price which is located in say D4 to come
up in B12
when Courier is selected the price to come which is located in E4 to come up
in B12
and the same with Air freight