View Single Post
 
Old 02-12-2020, 12:30 PM
DJ0691 DJ0691 is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default 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.
Reply With Quote