In N6 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=HYPERLINK("http://"&INDEX('Shipping Tracker Week X'!$F$2:$F$3000,MATCH(1,('Shipping Tracker Week X'!$B$2:$B$3000=A6)*('Shipping Tracker Week X'!$D$2:$D$3000=E6),0)),"Link 1")

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.