Using one number to refrence another

[pugsly8422]

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.

 

[Aladin Akyurek]

If the data area is in ascending order on its first column as it looks
from your sample...

=LOOKUP(E2,$A$2:$A$6,$B$2:$B$6)

=VLOOKUP(E2,$A$2:$B$6,2,1)

If the data area is not sorted...

=VLOOKUP(E2,$A$2:$B$6,2,0)

 

[pugsly8422]

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]

Thank you for your help, I can finally finish this worksheet. I really
appreicate it.

 

[Myrna Larson]

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