Onchange, vlookup event

[Pojzon]

Hello, I've got excel file with around 500-600 rows, which are often added/deleted. I could use a VBA code which will watch column A and whenever something changes in it, it would add vlookup (but only when vlookup table 1 is matching, case function perhaps, if thats possible, otherwise it shows #N/D! error) function to for example column J, so offset would be like (0,10). I tried to transfer vlookup function into VBA but I can't even seem to do that:

Please Login or Register  to view this content.

This code of course couldn't be used for my problem.
Small example in attachement, any help will be appreciated.

[nilem]

maybe so

Please Login or Register  to view this content.

[Pojzon]

Thank you for help, works fine, but can you tell me how to change

Please Login or Register  to view this content.

for last used row in sheet instead of 4th?

[nilem]

Please Login or Register  to view this content.

[Pojzon]

Awesome, thank you for help, +rep.