Dynamic List for Dropdown box

[pauldaddyadams]

Hi,

I had some help previously with a formula and I am trying to amend it to work on an additional list.

I have a box and based on that condition I would like a list populated.

e.g. In cell E24 the user selects the division which populates a number. This number (in cell G4) needs to be used as a lookup. Anything on the sheet "Activity Types by Network" with that code in column A the description needs to be returned to the help sheet.

The code I am using (doesnt work) is:

Please Login or Register  to view this content.

Which element is wrong? The list is to go in column V of the helper sheet

Paul

[Olly]

In V2, enter as array formula (Ctrl-Shift-Enter):

Please Login or Register  to view this content.

and copy down.

Fixed workbook attached.

[pauldaddyadams]

Hi,

thanks for that - I had to change it to A1 as it was pulling in an additional row I didnt want and this worked!!