VBA Vlookup not referencing without prompting

[milo1984]

Hi

I have a spreadsheet (attached below) which performs a number of tasks.

I am having a few issues.

1) The VBA Vlookup is not working like a formula vlookup. I log a number in column A in sheet "Logging In". I then log that number in "ITFC Returns"; but the Vlookup does not change the location in Column F unless I press F2 and enter on the original cell.
2) The result of the vlookup should automatically offset some dates. This only works when the result is "IN CHISWICK" as this is not the result of a Vlookup. Otherwise, once again, I have to press F2 and enter in that cell to activate the cell.

I am not sure what I can do to make the spreadsheet work without having to prompt the cells.

I have attached the sheet in the hope that someone will take pity on me and help me with my queries. I apologise for my basic code in advance


Many thanks

Booking In.xlsm

[milo1984]

Hi.

Would anyone be able to look into the above for me?

Many Thanks

[milo1984]

Hi

Do I need to rephrase the above or is it simply not possible?

I really would appreciate some sort of response

Many Thanks in advance.