Using one number to refrence another
 

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.

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 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.

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.

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

"Aladin Akyurek" wrote:

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 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.

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.