Without the helper column but needing to be array-entered (with
Ctrl+Shift+Enter, not just
Enter):
Code:
=IF(P2="","",HYPERLINK("#'File'!E" & MATCH(M2 & "|" & N2 & "|" & O2 & "|" & P2,$E$1:$E$900 & "|" & $E$2:$E$901 & "|" & E3:$E$902 & "|" & $E$4:$E$903,0),"Find"))
Note that I've used the likes of:
Code:
M2 & "|" & N2 & "|" & O2 & "|" & P2
instead of:
only to be more robust because:
2,32,32,32
and
23,2,2,232
both concatenate to the same
2323232
Using delimiters they're different:
2|32|32|32
23|2|2|232
so you won't get false finds.
See attached where I have engineered such a false find.