Zbor - Unfortunately it was putting it in the last row whether or not a match was found. I tried using your changes and it was still posting on the last row whether there was a match or not. I appreciate the help though.

TMS - I inserted those two words into the code and what an amazing difference it makes when you know where to put them!
It works perfectly now, updating the row exactly as I want it to! My next challenge is to take what you've helped me with and apply it to my first userform so information can be updated in that too, wish me luck!
Thanks also for helping me understand the code I used, didn't realise it wasn't stopping it's search after finding a match, though it makes sense once I think about it. You've been of massive help and I can't thank you enough!