Determining Value based on value in another cell

I am using Excel 2010.

In Column B, I have 8 digit codes for books. The first cell in Col B with data is B6. Headings are in row 5. The total number of rows varies.
Column B has numbers but they are formatted as text.
Please help me with code that would go down column A and automatically fill the column with values as indicated below.

If the first four letters of the value in B is 5400 then
Value in A should be "Library"

If the first six numbers in column A is 640000
Then the Value of A Should be "Office"

if the first six letters Column B is 640055 then
The Value of A should be "Office - GA"

If the code begins with 64 except the two above then
The Value of A should be "LAW"

All other codes should be "Misc"

Since you aren't comparing the same number of digits, it gets a little complicated to create a function. It might just be easier to use the filter/sort feature and enter in your five category names by section.

Kaper, this works very well as written. I also understand what you have done. However, there is one other issue:

How do I add the "other 64s" -- those starting with 64, but not being 640000 or 640055?

I have eleven 8 digit codes and will have between 400 to 800 rows of data.

Thank you.

Another:

Please Login or Register  to view this content.

Many thanks, John. I tested this over and over again and it worked perfectly every time.

You're welcome. Glad to help out and thanks for the feedback. Please review the Forum Rules and mark this thread as solved.

http://www.excelforum.com/forum-rule...rum-rules.html