Forum Discussion
Solved
Search part text in different columns and add 1 to return value
Hi I'm trying to make a search options for finding id codes [columnA] of material [columnB] and type [columnC] options. The value return can be from two different columns. But also the entered search...
YuanTSC Since your Excel version supports dynamic array functions, use FILTER as the main function to achieve what you want. Example workbook attached. The formula I used should translate into Dutch automatically when you open it. Hopefully it helps you find a solution for your real schedule.
YuanTSC Since your Excel version supports dynamic array functions, use FILTER as the main function to achieve what you want. Example workbook attached. The formula I used should translate into Dutch automatically when you open it. Hopefully it helps you find a solution for your real schedule.
Riny_van_Eekelen Thank you. Ill try that.