Hello Fantastic Excel SuperUsers:
I always like start off with saying thanks for all the help in the past! I have two formulas I would like to combine. =IFERROR(IF(SEARCH("specific text",cell value,1),other cell value I want to copy,cell value) and a INDEX MATCH formula.
Caveat would be, return value if true, return reference value if false but with the text plus hyphen of the new cell value.
E.g. 1) unique code returns value in cell a2 with the index match formula (easy enough)
2) unique code returns value in cell a3 if different from a2 that has numeric header 0000- <--Keep this but return "new value from index match and search formula.
Hopefully that made sense.
I always like start off with saying thanks for all the help in the past! I have two formulas I would like to combine. =IFERROR(IF(SEARCH("specific text",cell value,1),other cell value I want to copy,cell value) and a INDEX MATCH formula.
Caveat would be, return value if true, return reference value if false but with the text plus hyphen of the new cell value.
E.g. 1) unique code returns value in cell a2 with the index match formula (easy enough)
2) unique code returns value in cell a3 if different from a2 that has numeric header 0000- <--Keep this but return "new value from index match and search formula.
Hopefully that made sense.
