Hi Max

I have a similar query, and was hopeing you maybe able to help based on the
above?
I'm building a reporting template on one tab I hold all the DV List values
Customer, Sector, etc etc

The next tab is the actual report, in IT Open Issues Log!D4 They will define
the Sector, the values of which are on =Backend!$H$2:$H$7

when they are adding line items they will select the Customer affected they
do this in IT Open Issues Log!B7 for the first item and the Values come from
=Backend!$A$2:$A$131

The Next Item would be in B8, B9, B10 etc etc

What I would like to do is to have IT Open Issues Log!B* DV Lists filtered
by Sector, the Customer list has a Sector listed against it in
=Backend!$B$2:$B$131

I hope that makes sense??

If they would let me create a database i'd be happier, but they'd die if
they couldn't use Office Products to do management reporting
"Max" wrote:

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