It may be easier to add a column to the totals sheet such as AG6 that would have a formula that computed the following

Go to 2012_V
if L:L= 165 & N:N = 1
go to D:D and find the MAX number and post in AG6

If you agree, I would appreciate your suggesting the formula.

I will narrow the column search range down as you suggested.

Many thanks,
mrp