Search a cell for a string that exists in a list of values

Hello all -

This one has me stumped, but would make my life MUCH easier if someone could help me out, so here goes... I have a spreadsheet which is updated monthly with approximately 1000 rows of general ledger data. In the text field from our G/L system, our AP group enters one of our budget codes, which we must extract and enter into a new field. We currently have a formula that searches for the "BL#" prefix and then pulls in the next six characters, which is supposed to be the budget code. The problem is that the folks entering the data often time type "BL #" or "BC#", etc., forcing us to go back and manually seach a large volume of data for the budget code. Is there a way to define a list of valid strings (budget codes), search a cell to see of that string exists, and then return the string if found? I've attached an example that I hope will help... Thanks in advance.Sample.xlsx

I'm not entirely sure which way round you're trying to do this, so how's this for you?

This is EXACTLY what is was looking to accomplish. Thanks so much!!!