link text to number on other page

**vckim** · 05-30-2010, 07:32 AM

Hello everyone,

I am not a frequent user of excel. Now I want do to something specific, but don't know how.
In an excel file, I have one sheet with 2 columns. The 1st column has number 1 to 100 for example. The 2nd is one with text behind the numbers (different text for each number).
In the same file, in an other sheet, I also want 2 columns. There I want to type numbers in all the rows under column 1. In column 2 there should be automatically shown the text that stands in column 2 in the 1st sheet, behind the referring number.

example sheet 1: (this sheet is data and here won't be typed in)
column 1 - column 2
row 1 1 text A
row 2 2 text B
and so on

sheet 2: (here I only want to type numbers in column 1 - text should be shown automatically)
column 1 - column 2
any row 2 text B
any row 6 text F
and so on

Can someone tell me what kind of function(s) I have to use?
Hope it is clear.
Thank you.

Kim

**teylyn** · 05-30-2010, 07:48 AM

Hello Kim,

welcome to the forum. Take a look at the Vlookup function in the help files.

In your Sheet2 in column B, use a formula along the lines of

=vlookup(A1,Sheet1!$A$1:$B$100,2,False)

cheers,

**vckim** · 05-31-2010, 03:20 PM

Thanks for the information so far.
I am a little closer to what I want. But not exactly.

In this case you always need to fill in the number in the formula.
I would like that I just type a number in column 1 of sheet 2. If I typed that number, the text should be automatically shown in column 2 (same text that stands behind the same number in sheet 1).
Now I can search the text, but still need to type the numbers.

Hope you can help me again.

Thanks.

**teylyn** · 05-31-2010, 04:58 PM

In this case you always need to fill in the number in the formula.

No you don't. You put in the formula, then copy it down.
When you enter a value in column A, the text in column B is calculated automatically by the formula. No editing required.

Why don't you post a sample sheet. It will be so much easier to see what's actually going on. Click the Go Advanced button below and then the paper clip icon to attach a file.

**vckim** · 06-01-2010, 02:48 PM

Hello again.

Thanks for the answer.
I have a dutch version of excell. So I had to seek the formule in dutch. That way I couldn't copy your formula.
Now I checked your formula again and I found something wrong in mine.
Now I have what I want.

SO THANK YOU VERY MUCH.

**teylyn** · 06-01-2010, 05:10 PM

vckim, especially when you work in another language version, posting a file is better than posting a formula. Because Excel will translate the formula from the Dutch to the English version and also take care of the comma or semicolon delimiter for formulas.