article 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

 

[Bob Phillips]

Dominik,

In English, I think you want VLOOKUP.

Create a table with those numbers in 1 column, the values in the next.

In B1: =VLOOKUP(A1, G1:H100,2,FALSE)

G1:H100 is the table described above.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[RagDyer]

Try the Help files for
VLOOKUP
and
LOOKUP
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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