VLOOKUP doesn't impose any restrictions on the number of items in the list or
the size/length of those numbers.

On Mon, 3 Jan 2005 10:41:02 -0800, "pugsly8422"
wrote:

I also wanted to add that I would use the IF function, but since there are 99
different numbers and they go up to 10 digits each. I'm hoping there is a
faster and/or easier way.

"pugsly8422" wrote:

I have 2 lists and now thanks to help on here I can refrence the list the
way
I need to, now I've realized I need to be able to put in one number and get
a
totally different one. Here is the example

1 10
2 17
3 23
4 31
5 34

The numbers are in seperate columns. One of the numbers on the left will
be
entered and I need it to come back with the corresponding number on the
right.

Thanks again for your help.