Hello, I like to connect numbers and a description!
For example:

___----------A B
1 1234 Watch
2 1235 Jeans

If I put in a number I like to get the description automatic
Maybe I put the number 1234 in A1 at a other sheet then I like to get
the description Watch at b1. In Germany it is called “sverweis” but I
don’t know the English function!
Please Help me!!!!
Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Dominick

Sheet1 Column A contains numbers.

Sheet1 Column B contains Articles.

Sheet2 A1 is where you enter a number that would be on Sheet1.

Sheet2 B1 enter =VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE)

Sheet2 B1 will return the Article associated with the number you enter in A1

Gord Dibben XL2002

On Fri, 17 Oct 2003 17:50:32 -0400, dominik
<(E-Mail Removed)> wrote:

>Hello, I like to connect numbers and a description!
>For example:
>
>___----------A B
>1 1234 Watch
>2 1235 Jeans
>
>If I put in a number I like to get the description automatic
>Maybe I put the number 1234 in A1 at a other sheet then I like to get
>the description Watch at b1. In Germany it is called “sverweis” but I
>don’t know the English function!
>Please Help me!!!!
>Thanks
>
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi Dominik,
Hope it is English that you are looking for as an answer
VLOOKUP Worksheet Function and my webpage
http://www.mvps.org/dmcritchie/excel/vlookup.htm

I see Gord already answered, but the above may still be useful
to you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dominik" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hello, I like to connect numbers and a description!
> For example:
>
> ___----------A B
> 1 1234 Watch
> 2 1235 Jeans
>
> If I put in a number I like to get the description automatic
> Maybe I put the number 1234 in A1 at a other sheet then I like to get
> the description Watch at b1. In Germany it is called “sverweis” but I
> don’t know the English function!
> Please Help me!!!!
> Thanks
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>