You need to look into a VLOOKUP, be aware though that it will only look up
one value, eg. if the first sheet contains the same item multiple times, only
one will be returned on sheet 2, look into the VLOOKUP options and decide
which you need
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"JoJo" wrote:

Folks:

I have 2 spreadsheets. The first consists of 5 columns & 4000 rows of
information. The 2nd consists of 1 column and about 10 rows.
I am looking for an Excel command that would allow me to take each piece of
data from spreadsheet #2 and perform some sort of LOOKUP in table #1 then
bring back the other 4 columns of information.



Thanks,
JoJo