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.
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.
