Using offset with lookup

[john_wheaton]

I'm trying to find the first empty cell in a column on one sheet, then insert the value in the adjacent cell to the left into a cell on a different sheet,

using this formula:

=offset((LOOKUP(1E+307,'[PO Log.xlsx]PO Log'!B:B)),0,-1)

But I keep getting an error popup.

[Jonmo1]

Try

=LOOKUP(1E+307,'[PO Log.xlsx]PO Log'!B:B,'[PO Log.xlsx]PO Log'!A:A)