You don't need a macro.

Assume the matching column is in column A on both sheets

in B2 (for example) of the smallsheet, put in the formula

=vlookup(A2,'[Bigsheet.xls]Sheet1!$A$1:$D$500,3,False)

this retrieves the value form column C in the Bigsheet for a match.

It returns #N/A if not found.

You can then drag fill it down the column.

--
Regards,
Tom Ogilvy

"morry " wrote in message
...
Hello,

I have two spreadsheets that have some matching values. For
example: RE518602. One big spreadsheet has all of the available
numbers and there are many small sheets that have some numbers in them.
I need to write a macro that will look at all numbers in a small sheet
and find the matching number in the main (big) sheet. After I match
them I need to extract a different value that is in the same row but
different column (on the big sheet) and paste it in a column in the
small sheet. (All sheets are in separate workbooks.)

If someone can help me with this problem it would be greatly
appreciated.

Thank you
Morry


---
Message posted from http://www.ExcelForum.com/