I have started just recently into VBA. I am working on a vlookup formula. Thought I could simplify it using an R1C1 formula but it won't work for me.
I am looking up one one sheet and referencing another sheet. I have about 50 rows of data list.
Here is the VBA code that is working for...