Trying to combine two formulas

Hello. I have two working formulas that perform separate functions: =IFERROR(VLOOKUP(A4,$C$4:$E$39 uses the user input to search a partial word, while =HYPERLINK("#"&CELL("address",INDEX($E$4:$E$36,MATCH(E4,$E$4:$E$36,0))),E4) assigns a hyperlink to the search result and takes the user to the data it is associated with. My problem is I am unable to combine the two to get both results all-in-one. Also, I read somewhere that VLOOKUP can't be used with INDEX MATCH. Is there an alternative?

Find more posts tagged with

hyperlink

Accepted answers

Paul Newcome

These look like Excel formulas. Are you wanting to convert these into Smartsheet formulas, or maintain them in Excel? If you are wanting to maintain them in Excel, then you may want to look for an Excel based Community/Forum.

All comments

Paul Newcome

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.