=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.


"alen_re" wrote:


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: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=501721