Les

The data is Text.

There is no "between" for text as there would be for numbers.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 15:16:00 -0700, Les wrote:

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.