Hello,

My first post, so thank in advance for any help!

I am trying to use data validation and dynamic drop downs using the following formula. This returns the cell values I want (a list of names dependent upon their class). This currently works, however I want to amend it to return only the first 2 letters at the left of the cel. The current data validation forumla is:

=OFFSET(regstart,MATCH(C2,regcolumn,0)-1,1,COUNTIF(regcolumn,C2),1)

I thought that this would work, however it does not:

=LEFT(OFFSET(regstart,MATCH(C2,regcolumn,0)-1,1,COUNTIF(regcolumn,C2),1),2)

Any ideas?

Thanks very much.