Need help to correct an ADDRESS & MATCH formula for Hyperlinking hlookup result

Originally Posted by Jonmo1

The syntax of the Address function is

=ADDRESS(ROW#,COLUMN#,abs,a1,sheettext)

You seem to have the Row and Column reversed.

Hi!
I know the syntax but I still cant get it to work.
Can someone please give the exact formula or modify it in the attached worksheet?