I attached my interpretation of what you needed. I used a Index/Match to find the value from the Data Sheet on the Zone sheet.
You are going to have issues with this data however. I noticed you dont have any unique data on your Zone sheet. With out a unique key, finding the right column "C" field is going to be impossible. The current formula just finds the first value that matches:
Basic "AH" Column Formula:
You said you wanted a semi-colon to separate data. This formula just concatenates Column A with the result of the formula above, separated with a semi colon. The & is your concatenation
Lastly, your data is sometimes not on your Zone sheet, i put in an Iferror to say "not found" if the PCL number doesn't exist
Cheers,
Don
Bookmarks