Hi i am trying to use a hyperlink formula where i want to return a number from another sheet and create hyperlink to that number.

I have used:

=HYPERLINK("[Martin_0.xlsx]UW!D4"; UW!D4)

Which gives me the correct value and creates the link. But if i change the file version to _1 or _2 the link doesnt work. What can i do to make the file name dynamic?

Thanks

Br

Martin