Using HLookup for DV lists

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi

I'm building a reporting template in a workbook on one tab "Backend" I hold
all the DV List values Customer, Sector, Region, Month etc

The next tab "IT Open Issues Log" is the actual report.
In IT Open Issues Log!D4 They will define the Sector using a DV list, the
values of which are on =Backend!$H$2:$H$7

when they are adding line items they will select the Customer affected again
using a DV list 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, e.g If it is the Automotive Sector Report then only
the Automotive Customer should show in the DV List.

Am i using the right solution or is there a smarter way of doing this?

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,

Fantastic thank you, solution is great, I had a hunch i'd need to reaarange
the data.

I'll look around to see if there is a slicker way of setting up the lists
but for now it does the job exactly as i need.

5 star for coming back so quickly
p.s
I totally agree with you What works in one Scenario won't work in another.
 
Back
Top