software

Sorry.. title is strange..

I have two worksheets.. In both of them I have two same columns - Code
and Name..

In one worksheet is a list of all codes and names, and I want in other
one to put only a code in a cell and to get a name from the other
worksheet (that has a same code).. if you know what I mean--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=501721
See if this example covers your situation

On Sheet1 you have a list.
A1: Code
A2 through A??: code numbers
B1: Name
B2 through B??: names

On Sheet2:

A1: Code
A2: (a code number)

B1: Name
B2: =VLOOKUP(A2,Sheet1!A1:B100,2,0)
(returns the name on Sheet1 that is associated with the code in A2)

Copy that formula down as far as needed

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=501721=VLOOKUP('codes without names'!A2,'codes with names'!$A$2:$B$4,2,FALSE)

'codes without names'!A2............ is the code your trying to lookup

'codes with names'!$A$2:$B$4.......is the table that has both codes and names.quot;alen_requot; wrote:

gt;
gt; Sorry.. title is strange..
gt;
gt; I have two worksheets.. In both of them I have two same columns - Code
gt; and Name..
gt;
gt; In one worksheet is a list of all codes and names, and I want in other
gt; one to put only a code in a cell and to get a name from the other
gt; worksheet (that has a same code).. if you know what I mean
gt;
gt;
gt; --
gt; alen_re
gt; ------------------------------------------------------------------------
gt; alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
gt; View this thread: www.excelforum.com/showthread...hreadid=501721
gt;
gt;


Actually, for copying the formula down, it needs this form:

B2: =VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)

Or

you could name the lookup range on Sheet1 and use that name.

Sheet1, select the list range
Editgt;Namesgt;Define
Names in workbook: LU_NameCode
Refers to: (the already selected range)
Click the [OK] button

Sheet2:
B2: =VLOOKUP(A2,LU_NameCode,2,0)

I hope that helps.

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=501721
I've tried what you said.. but it's probably up to me, and I can't get
it to work.. I'm not so good with excel

So, I'll try to be more specific..

Sheet1
A1 - Code (A2 - A.. actual codes)
B2 - Product name (B2 - B.. actual names)

(This sheet has the list of 500 codes with names)

Sheet2
A1 - Code
B2 - Product name
(C3 - Quantity)

So.. I want to add quantity in Sheet2 and to put only a code.. and I
want formula to find a product name for the code..--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=501721
Your references seem to include some typos, but.....

On Sheet2, if you enter a Code in cell A2, then this formula (which I
posted earlier) should return the Product Name associated with that
code:

B2: =VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)

Adjust the sheet and range range references to suit your situation.

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=501721
Thanks a lot for the help... It helped me ofcourse.. but I found one
thing that didn't fit..

You said: B2: =VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)
I made a correction: B2: =VLOOKUP(A2;Sheet1!$A$1:$B$100;2)

Problem with ; and ,

I'm using Office 2000.. why is this ?!
Ron Coderre Wrote:
gt; Your references seem to include some typos, but.....
gt;
gt; On Sheet2, if you enter a Code in cell A2, then this formula (which I
gt; posted earlier) should return the Product Name associated with that
gt; code:
gt;
gt; B2: =VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)
gt;
gt; Adjust the sheet and range range references to suit your situation.
gt;
gt; Does that help?
gt;
gt; Regards,
gt; Ron--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=501721