Check if cell value is between two numbers

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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

The data is Text.

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


Gord Dibben MS Excel MVP
 
You could perhaps use something like this?
check1 = False
Check2 = False
check3 = False
If Int(myNum) >= 10000000 And Int(myNum) <= 13609999 Then
check1 = True
ElseIf Int(myNum) >= 100000 And Int(myNum) <= 139999 Then
Check2 = True
ElseIf Int(myNum) >= 1000 And Int(myNum) <= 1399 Then
check3 = True
End If
If check1 = False And Check2 = False And check3 = False Then
'run your code
End If
 
Well done Libby

Gord

You could perhaps use something like this?
check1 = False
Check2 = False
check3 = False
If Int(myNum) >= 10000000 And Int(myNum) <= 13609999 Then
check1 = True
ElseIf Int(myNum) >= 100000 And Int(myNum) <= 139999 Then
Check2 = True
ElseIf Int(myNum) >= 1000 And Int(myNum) <= 1399 Then
check3 = True
End If
If check1 = False And Check2 = False And check3 = False Then
'run your code
End If
Click to expand...
 
Back
Top