i want to make a listing in sheet2 coming from sheet1 with a selection of all the words 'rechtstreeks' that are in column D1 to D100. In the sheet2 there has to be visual the fields form column A,B and C - corresponding the fields in the same row from the selection 'rechtstreeks'.


what is the formule for that question ?

Hello & Welcome to the Forum,

In this case, sure would help if you attach a sample to work with.

Make sure the sample has enough of a representative example of before and after.