Skip to main content
Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • I am confused about what your question is. How does your code not work? What does it do or not do?
    – Rohit Gupta
    Commented Oct 3, 2023 at 22:20
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Oct 3, 2023 at 22:20
  • If CMD!E2 equals 1... I want CMD!A5 to return whatever is in NonBrand!A5 (It contains a hyperlink to a document template). Else check if CMD!E2 equals 2... I want CMD!A5 to return Agile!A5 (It contains a hyperlink to a document template) else....etc. through CMD!E2 equals 6.... If nonBrand!A5 doesn't contain a hyperlink just return the text. the hyperlink that it returns gives an error when clicked on that the site cannot be opened. It is internal to our co. The cells that do not contain hyperlinks are returning hyperlinks that obviously don't work not just the text in the cell.
    – Rita
    Commented Oct 3, 2023 at 22:43
  • Prior to adding the HYPERLINK portion into the formula, the nested if worked but it did not return the hyperlink, just the text in the cell.
    – Rita
    Commented Oct 3, 2023 at 23:05