Need a bit more information, where are you inputting a number?

--

Regards,
Nigel




wrote in message
...
i have 2 columns one column can be a number between 1 and 200,
depending on the number inserted there has to be a number between 1
and 20 outputted on the left

column 1 column 2
1 1-10
2 11-20
3 21-30
4 31-40
5 41-50

and so on if a number between 1 and 10 is inputted a 1 should appear
to the right