I have three lists -

1 = Clients (AC3)
2 = Locations (E54)
3 = Sites (R54)

Within the clients drop down box i have this code in the validationsection: -
=IF(E53="",Client,INDEX(ClientColumn,MATCH(C2,Loca tionColumn,0)))

This code in the Locations validation section: -
=OFFSET(ClientStart2,MATCH(AC3,ClientColumn2,0)-1,1,COUNTIF(ClientColumn2,AC3),1)

'ClientColumn', 'Client', 'LocationColumn', 'Client Start' are all data
names and contain the lists.

Can anyone help with the code that is needed to go in the final box to bring
the list up for the Sites. The name for this list is 'SiteColumn'

Please help!