Hi Forum,
I am building a spreadsheet, to track work, and the URL may change depending on which system we are using to track the work - we currently have 4 likely locations, and the work may move from one to another.
In column A - I select the location of the column - so B populates the cell with the correct URL from (in the attached example) columns C,D or E using an if statement.
The problem I have, is that all the links work in columns C,D and E but when displayed in B - they don't work.
Perhaps the "if" statement isn't the way to do this - I'd prefer not to use macros if possible.
I like to hide the URL with a friendly name - so I can't use the text URL and hyperlink it - this works but is ugly.
Can anyone help?
Bookmarks