I haven't been successful in executing a conditional hyperlink whereby if the statement is True then ordinary (non-hyperlinked) text is placed in a cell and a False results in a hyperlink. Here is the formula I am using:
=IF(VLOOKUP(CONCATENATE(A2,B2),revapp1,4)="Coincid es with Approval","Coincides with Approval",HYPERLINK(VLOOKUP(CONCATENATE(A2,B2),rev app1,4)))
Even when the condition is True, the text (Coincides with Approval) appears as a hyperlink.
Anyone know how to make this work?