Calling Jim Cone - OFFSET Function

L

Lynda

Hi Jim
I wasn’t sure whether I should move this to Worksheet Functions or stay
where you had helped me before in the General Questions area. I have been
persisting at home with the problem I am having with the OFFSET function.
I have managed to get most of them working, the ones I am having trouble
with now are those that are attached to a dependant drop down list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet 3(Data)
D38 (got this one working) Column A G3
G38 (this one is dependent on D38) Column B H3
K38 (this one is dependent on G38) Column C I3

E44 (got this one working) Column O K3
H44 (this one is dependent on E44) Column P L3

Are you able to give me any hints on how to overcome this problem? You have
been very patient and I thank you very much for your help.

Cheers
Lynda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top