Offset Question

[gmazza76]

Good afternoon,

I have 3 Offsets working against listings etc... and have seem to come across an error and could do with some direction.
I have 3 sets of data as follows
Make - used to filter to Model
Make/Model - to show the model
Model/Spec - to drill down to model
Make down to model works with following formula
The second formula works, but it has the first option showing as the different Make. Ie if ford is selected, the first one would be from the previous make etc...

=OFFSET(MakeST,MATCH(F6,Make,0)-1,1,COUNTIF(Makel,F6),1) - Works
=OFFSET(ModelS,MATCH(F8,Model,0)-1,1,COUNTIF(Model,F8),1) - Partly works
[/end]

Is there a way round this?

thanks in advance

 

[Toadstool]

Hi GMazza76,

Can you show us some sample data and which cells are referred to by the names Make, Makel, ModelS and Model?