hyperlink formula is not changing relative when copied to other calls

[Al-1_2surf]

In the attached file is a screen shot of a formula of a hyperlink function in are cell, when I try to copy it to other cells the cell reference of the (IF) partof the function changes relative but the two hyperlink cell references do not change, the formula is working but I need to manually change each line which is very long, does someone know how I can get this corrected

[#2 · Accepted solution]

@Al-1_2surf 

Hi! The two last references are not working because they are inside double quotes. Please try to replace

FEEDBACK'!C9"

with

FEEDBACK'!" & C9

in the last two references.

[#3]

Thank you it worked, something so simple now that Isee it, won't make that Mistake again, how do I make this thread solved-

[#4]

@Al-1_2surf 

It happens a lot that the solution is right there and we can't see it. :) Glad that I could help.  Good luck with Excel!