Forum Discussion
Solved
Index, Match, Trim?
Hello! I have been struggling with this formula for days now. Any help would be greatly appreciated! In sheet1, column D I have a list of values. D1 20375 D2 456 D3 203755 D4 1234 D5 5678 ...
In H1:
=IFERROR(INDEX(Sheet2!$A$1:$A$50,MATCH("*"&D1&";*",INDEX(Sheet2!$C$1:$C$50&";",,),0)),"")
Adjust the ranges if needed, then fill down to the last used row.
Yay! This seems to have worked. Going to test on my full data set now. THANK YOU! (Is there a place where I can read/learn about what each segment is doing?)
Creating such formulas is mostly experience and a lot of experimenting.
See 500 Excel Formula Examples for lots of useful examples.