Hello

I have Excel Spreadsheet, with the following columns containing a list of
our office with an office code. ':' is the column seperator here

Code:Office:Selected?
LEI:Leicester:Y
NOT:Nottingham:N
SHF:Sheffield:N
DON:Doncaster:Y
MAN:Manchester:N
BHM:Birmingham:Y

On a seperate sheet, I have a box that I want to populate with a list of
office codes, seperated by a comma, which has a 'Y' in the selected column.

So, in the example above, this box on the seperate sheet would show as

Offices Selected: LEI, DON, BHM

I'm thinking a CONCATENATE string, but can't work out how to do a look up
the column and identify the code in column A if column C=y...


Can anyone help please?

Thanks

Ben