The problem is the row number using the Match() function. The Match () returns the first match it finds in the array, so if i have 2 prices that are the same(value I'm searching for) Match returns the first, which might not be the value I need. Is there a way to reference the row in Column H on the takeoff sheet? This is the value(Price) from the Kitchenette sheet and contains all the value I need to copy. I guess the other approach would be a dynamic array of some sort.