The vba codes below are similar in scope, except the first code only looks up one price, however the second code is suppose to loop through each row to get each price in the range. However, it does not accomplish the task. I'm keeping getting the same numbers each time I run the second code...