Vba vlookups

Alright my apologies. Attached is my workbook.

Hi,

A lookup is pretty easy to perform, it might be a good idea to remove the blank spaces as well if that wont cause any problems.......

im going to write this generally so you will have to study it for a few minutes ....

first the VBA lookup, its super simple and likely faster than any formula

Please Login or Register  to view this content.

Hope this helps a little, i really dont recommend using formulas or worksheet functions within VBA, sometimes its convenient but the problems usually outweigh the benefits....


Thanks
Paul S.

OK so after a rather rude private message by someone (utter nonsense really...) i decided to follow up on the code i left to help you and built the whole thing for you.....People may not like my methods but i think sending a different angle to view triggers a better response and better thinking than simply handling you a bunch of workaround fixes which will again lead to more problems.... sorry as a professional developer thats just how it usually goes....

My previous post would have forced you to rethink how you wrote your code (nothing wrong with it except it wasnt working right so it needed fixing) try and have a look at how i coded this and follow the simple flow of logic..... coding this way will help you troubleshoot problems alot easier.......

you will need to add some things, for example your sample file only has 3 columns on sheet2, im not sure if you plan on adding more but its easy to do, if you need help just reply



Thanks
Paul S.

PS. your old code is still in there so you can compared and make adjustments

Working Example.xlsm

Thank you very much! I actually really appreciated the first method, I am looking at the two different codes now however to get a better feel. Like I said, I've only been working with this for a short time.