Goto range based on value of another range(reverse vlookup??)

Hi again, what I would like to do with this is when you doubleclick range E1, a msgbox pops up asking if the lot number in the list Q1:R4 is correct. If no, then based on the selection in D1, the correct cell is selected in the range Q1:R4, so for this example, when you answer no, cell R2 would be selected, and if you did the same in E2, then cell R4 would be selected because of the value in D2. Thanks again for the help and hopefully this time I have explained it well and also provided an example worksheet!

Thanks Vragg, your code works perfectly in the example worksheet, but doesn't in the worksheet I need the code in. It throws a "Runtime error 13, Type mismatch" error on this line, "x = Application.Match(Target.Offset(, -1), Columns(17), 0)".