Im using the following formula to show specified data from a cell in excel, I want to add Caption below linked to a specific cell in the same row and want to drag the formula down.
My current formula reads as:
=IMAGE(“https://quickchart.io/qr?text=”&N2,N2,3,150,150)
Please assist with:
- Adjustment to formula to add the caption (Linked to cell)
- Ability to change the Font type and size (eg. Arial, Bold, 14)