In the following formula:
=ALS(VERT.ZOEKEN(A19;Keywords!$A$2:$H$10;KOLOM();ONWAAR)="";"";VERT.ZOEKEN(A19;Keywords!$A$2:$H$10;KOLOM();ONWAAR))
I want to repace A19 by a formula like: "A" & ROW()+ 1, making:
=IF(VLOOKUP("A" & ROW()+1;Keywords!$A$2:$H$10;COLUMN();FALSE)="";"";VLOOKUP(A19;Keywords!$A$2:$H$10;COLUMN();FALSE))
When I try the formula is a separate cell, it works. In the vlookup formula, it doesn't.
The question is: why????
Thanks for answering
Bookmarks