Hi
Id be grateful for some help with a hlookup formula which is supposed to return the value, but also any hyperlink associated with that value
The formula is as follows
but the error is 'Cannot open the specified file'
I've looked through the forum and there is a suggestion to include a '#' but either it isnt working on my syntax / placement is wrong.
Most appreciated!
Thanks
A
Id be grateful for some help with a hlookup formula which is supposed to return the value, but also any hyperlink associated with that value
The formula is as follows
Code:
=HYPERLINK(hlookup(C$1,Master!$C$1:$BM$150,ROW(),FALSE)),"")
but the error is 'Cannot open the specified file'
I've looked through the forum and there is a suggestion to include a '#' but either it isnt working on my syntax / placement is wrong.
Most appreciated!
Thanks
A