I used macro recorder to try to understand the vlookup function in vba. Can someone tell me how to have that same vlookup function where it looks at the whole column where there is data and stop when it hits the last cell. Also, the results of the vlookup populate in the corresponding cell. I hope this makes sense.
Here is the code the recorder populated:
Any help would be appreciated.