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