You need to loop through the values in Column A and if the cell value in the row at [loop count] (usually i or j) equals “novel” then add the value in Column B at [loop count] to a list.
Do not use the “first occurrence of” block. That’s only for single searches, not for loops.
You can see an example here: Performing a VLOOKUP in LocalDB