Conditional Format to Add List of Text Based Upon Cell Contents

[mkedyr1969]

We have projects in various states. Some of the states that we conduct business in have special building code requirements...
I have a spreadsheet of the projects and a column listing which state they are in, for example TX.

I'd like to list on a separate sheet, the codes required by that state. In each row, a separate code requirement. For example, on sheet-2 column-A, the codes for TX in rows 1-10; Column-B, the codes for HI in rows 1-10; Etc.

Back on sheet-1, I'd like a column set up for special codes.
If the "state" column lists TX, then the "special codes" column would list all of the corresponding codes for that state.

Thanks in advance for your help.
Mike

[FDibbins]

Hi, welcome to the forum

You can probably do this with a vlookup or INDEX/MATCH, but I would need to see a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[ChemistB]

Hmmm, the issue here is going from maybe 10 cells on sheet2 (TX in A2:A11) to just a single cell on Sheet1. Will that cell be very crowded? Maybe an option would be a dropdown menus which would show you all the TX codes. This would work if you're primarily working with an electronic copy but would not be useful for a printed copy.