Hi Rogcar,

I will address each of these concerns.

1. the vlookup should stay in your first worksheet. You mentioned that you corrected the formula to work so you can use that same formula. The different part is if you get a #N/A from the lookup you can change just that lookup to include the team name as well. You will need to look at the red highlighted names to see what it changed the SearchString into.

2.Yes that is possible. You just need to change your formula to have IfError( in front of it. I believe the formula would be
3.The shape does not have much to do with the script. It is just a way for you to run the script by clicking on it. You can place the shape anywhere in the workbook you like as long as you have assigned the macro to it, it will work.

4.The script will automatically create the DataScrape sheet if it is not there. However if you choose to delete while you have your vlookup formulas on your first sheet you will get a #REF error and will need to rewrite the formulas when the DataScrape Sheet is recreated. It does not matter where in the workbook the DataScrape sheet is you can move it to the end or do what you wish with it.

5.What a nice note. I appreciate the questions. I have a project for work coming up that needs this same type of coding so this is really good practice for me. Thank you for the kind words.