I suggest trying a vlookup (or maybe a "Getpivotdata") formula in the spreadsheet before attempting to code it into a macro. For further details on Vlookup check the Excel Help Files. Once you are happy with a formula approach you can could then convert it into a macro...

hth
Rob