Trying to combine two formulas

TinaB

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?

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.

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.