Hi
use VLOOKUP. e.g.
=VLOOKUP(A1,'sheet1'!A1:B100,2,0)

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
I had two spreadsheets. The first contains two columns of
data, and on the second I wish to set up an equation (no
macros or sorts) so that when I type in a value from the
first column of the first spreadsheet, it will
automatically return the corresponding value from the
second column. What do I do?