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?
Help Article Resources
Check out the Formula Handbook template!