That worked great
Thanks again for the idea - worked like a charm. Here is what I did:
1) Created the helper column K and populated with =E3&E4&E5&E6 on each row. Column E has the individual numbers. The creates one larger number in that cell in column K.
2) Made an input area in cells M2 thru P2
3) In cell Q2, entered the formula:
=IF(P2="","",HYPERLINK("#'File'!E"&(MATCH((M2&N2&O 2&P2),K:K,0)),"Find Pattern"))
4) This creates a hyperlink for user that brings them right to the pattern they are looking for - and only displays when numbers are entered in the input area.
|