Explanation
The hyperlink function allows you to create a working link with a formula. It takes two arguments: link_location and, optionally, friendly_name .
Working from the inside out, VLOOKUP looks up and retrieves a link value from column 2 of the named range “link_table” (B5:C8). The lookup value comes from column E, and VLOOKUP is configured for exact match.
The result is fed into HYPERLINK as link_location , and the text in column E is used for friendly_name .
HYPERLINK returns a working link.
Explanation
This formula looks complicated, but, at the core, it is quite simple, and created in two parts like so:
= (formula for number1) &":"& (formula for number2)
On the left, the GCD function is used to calculated the greatest common divisor (GCD) of the two numbers. Then the first number is divided by the GCD. On the right, the same operations are performed with the second number.
Next, the result of the right and left operations are joined together using concatenation, with the colon (":") as a separator. So, altogether, we have:
=B4/(GCD(B4,C4)) &":"& C4/GCD(B4,C4)
=1280/(GCD(1280,720)) &":"& 720/GCD(1280,720)
=1280/80 &":"& 720/80
=16 &":"& 9
=16:9
Note that the final result of this formula is a text value.
