http://metachat.org/index.php?disp=comments en-US http://backend.userland.com/rss 60 Thu, 03 Sep 2009 17:07:58 +0000 c501922@http://metachat.org Put the codes and names on a new sheet (where the codes are sorted numerically) and use @VLOOKUP on the codes to find the names. http://metachat.org/index.php/2009/09/03/excel_question#c501922 Fri, 04 Sep 2009 03:23:40 +0000 c502004@http://metachat.org First make a table of key:value pairs.... ie 1234 smith in A1 and B1, and so on down (no need to sort or anything) then, presuming your numbers are in column D and you want results in column F, F1 becomes: =vlookup(D1,A:B,2,0) & " | " & D1
then, presuming your numbers are in column D and you want results in column F, F1 becomes:

=vlookup(D1,A:B,2,0) & " | " & D1




]]> http://metachat.org/index.php/2009/09/03/excel_question#c502004 Fri, 04 Sep 2009 19:48:02 +0000 c502079@http://metachat.org This is probably a moot point by now, but a hack that might work that looks less scary than the actual solutions proposed above: Open a new Excel worksheet. In column 1, fill in a series of sequential numbers. In column 2, copy and paste your codes from the first sheet. Now sort this new sheet by codes, and fill in the last names. Now resort this sheet by your first, sequentially-numbered column. Now copy and paste the column of last names, which should now be in the same order as on the original sheet, into your original sheet.
Open a new Excel worksheet. In column 1, fill in a series of sequential numbers. In column 2, copy and paste your codes from the first sheet. Now sort this new sheet by codes, and fill in the last names. Now resort this sheet by your first, sequentially-numbered column. Now copy and paste the column of last names, which should now be in the same order as on the original sheet, into your original sheet.]]> http://metachat.org/index.php/2009/09/03/excel_question#c502079