Thanks for getting back to me. I guess I just aren't following your
suggestion. I did an =mid to pull out the Cost Center and Fiscal Year from
the long string we have, did a paste special value, and then tried to do a
VLookup to another worksheet that has a master list of Cost Center and Fiscal
Years but it won't work. Funny, if I manually type what I pulled out using
the =mid, it works like a charm. I really appreciate your willingness to
help.

"merjet" wrote:

I don't get your second point. If the calendar month changed, the
Fiscal Year would change only if the calendar month matched the First
Fiscal Month. The Fiscal Year would be pretty static.

Hth,
Merjet