Hi everyone, 

hopefully anyone of you can help me with the following problem. 

I want the value of B10, B11, B12 etc. of Sheet1 be filled in in cell F10, F11, F12 etc. on Worksheet, when cell K10 of Worksheet matches (complete of partial) with cell A10, A11, A12 etc. on Sheet1. 

Worksheet:

Sheet1:

I have tried several formulas, such as =ALS.FOUT(VERT.ZOEKEN($K10;Blad1!A:E;5;ONWAAR);”Niet gevonden”) and =VERT.ZOEKEN(E21;Blad1!A12:E357;Blad1!D12:D357), but both don’t work.

Hopefully you can tell me what i do wrong. 

Thanks in advance.

With regards,

Diana

​Hi everyone,  hopefully anyone of you can help me with the following problem.  I want the value of B10, B11, B12 etc. of Sheet1 be filled in in cell F10, F11, F12 etc. on Worksheet, when cell K10 of Worksheet matches (complete of partial) with cell A10, A11, A12 etc. on Sheet1. Worksheet:Sheet1:I have tried several formulas, such as =ALS.FOUT(VERT.ZOEKEN($K10;Blad1!A:E;5;ONWAAR);”Niet gevonden”) and =VERT.ZOEKEN(E21;Blad1!A12:E357;Blad1!D12:D357), but both don’t work. Hopefully you can tell me what i do wrong.  Thanks in advance.With regards,Diana     Read More

​