Starting an empty cell I would like to lookup the value in the cell above, in a different worksheet in the same workbook, and then return the value below this, but only when the cell in the column next to the looked up value is empty.
Ideally I would like this to then move down a cell and keep filling until the conditions arent met- but even one cell at a time would help.
Have tried lots of things but not sure where I'm going wrong......
Thanks
nic