Hi all,

I have a column of names. For each name in the column, I want to look up that name in a second workbook and save the value 8 columns to the right as a variable. Then I'll take that variable, and search column A for that value. Once I find that value, I'll multiply each value in the original worksheet's name's row...

So basically...
1) for each cell in column A in workbook1, sheet2
2) find matching value in workbook2
3) save activecell.offset(0,8) of the matching value in workbook2 as variable
4) go back to workbook1. find the activecell.offset(0,8) in the original workbook

So if I look for "A" in workbook2 and the activecell.offset(0,8) returns me a value of Apples, then I search column A for Apples (lets say its in row2)

Any comments/suggestions accompanying code to help me learn are very welcome. Thanks!