articel number??????

[dominik]

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

 

[Gord Dibben]

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

 

[David McRitchie]

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.