Assuming the entry 1 is in A2 of Sheet1 and the entries 1 and poiu are in
A2 and B2, respectively, of Sheet2:
In C2 of Sheet1 use =VLOOKUP(A2,Sheet2!$A$2:$B$999,2,FALSE) to get the data
needed in C2 of Sheet1.
best wishes & Merry Christmas
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ed" wrote in message
...
I have 2 spreadsheets with related data

spreadsheet1:
code data1
1 asd
2 qwe
3 zxc
etc (very long list... with several more columns...)

spreadsheet2:
code data2
1 poiu
3 lljh
etc (list can be short, with more columns, and updateable) all codes in
spreadsheet2 ARE included in spreadsheet 1

is there a way to append this data, so that it will show something like:

code data1 data2
1 asd poiu
2 qwe
3 zxc lljh