If I understand correctly, the primary issues here are:
- Sometimes the book is empty so you have to assume the last book value higher in the column.
- Sometimes the author or ISBN is empty and you want to choose to use only one based on it being non-empty.
Given I don’t know the structure of the site you are entering the data into, this may change a little bit, but the high level way to approach this is inside an “Excel For Each Row” add two if statements:
- Check if the “Book” value of the current row is not empty, if it is not empty write that value into a temporary location in the project notebook (e.g. Scratchpad!A1). This is now your current book and anytime you need it, get the value from that cell in the project notebook (it will always contain the most recently seen non-empty book name value)
- Assuming author would take priority over ISBN, check if the “Author” is not empty (if you prefer ISBN to take priority check that instead) then inside the “Then” “Else” statements take the appropriate actions.
In the screenshot, I’ve assumed that either the Author Name or ISBN would go into the same field, so I’ve just stored them in a “value_to_enter” cell in my project notebook so I could use that value in a “Type Into” activity but if you put them in different places you’d want to put the actions directly in the “Then” and “Else” blocks.