Hi all,

I have a list of code numbers, 8 digits each in column A, formated as Text.

I need to do a look up to another sheet and if found bring in a department
code, but i must first check if the value per cell in column A is between

1. 10000000 and 13609999, then between
2. 00100000 and 00139999 and then lastley between
3. 00001000 and 00001399

If not then my code

Any help would be much appreciated.

--
Les