That worked great, Jakob. Thanks!

"Jacob Skaria" wrote:

Dear Mark

You can use a combination of INDEX and MATCH functions to achieve this.

Workbook INdex.xls Sheet1 contain index numbers and names in ColA and ColB
Current workbook Sheet1 Col A1 = number . Use this formula to retrieve the
name from Index.xls

=IF(ISNA(MATCH(A1,[INDEX]Sheet1!$A$1:$A$3,0))=TRUE,"",INDEX([Book2]Sheet1!$A$1:$B$3,MATCH(A1,[INDEX]Sheet1!$A$1:$A$3,0),2))

If this post helps click Yes
--------------
Jacob Skaria

"Mark P" wrote:

I have an index spreadsheet that lists a code number for an item in one
column and the name of the item in a different column. I want to use this
information in different spreadsheets that have only the code numbers. Is it
possible to take a code number in one spreadsheet, search for it in the index
spreadsheet, copy the corresponding name, and paste the name back into the
spreadsheet that just has the codes?

Thanks!