? Find method
 

Greetings and TIA for your time
I am working on a procedure with the following steps
1) Paste a short list of names in column 1 sheet 1 workbookbook 1
2) In col 2 create a lookup formula for each name in sheet 1 book 1 to
obtain a value from the full list of names and values in book 2
3) operate on the values in book 1
4) Update the values in the full list of names and values in book 2 with the
updated values in book 1

Would the Find method be the best way for step 4?
--
David