I have a workbook with 2 excel sheets. In the first one i have an id and name column. My code runs through each row in the id column and looks up the id in a table on the other worksheet and retrieves/pastes the name int he name column and movbes onto the next row. There are only about 10 different id's but i ahev doing a VLookup for every row and there are 500 rows and increasing at the moment. Is the a better way to do this where i can look up say id 1, retrieve its name and then paste the answer for all the id 1's and so on????