n is an integer, LR is long, Tminus1 is a worksheet
I am doing a vlookup using index and match. The formula works when its in the sheet and when I transferred it to vba, it worked until it got to a lookup value thats not in tminus sheet which I am looking up against and instead of inserting no data like i thought it would, I am running across an error: Run-time 1004: Unable to get the Match property of the WorksheetFunction class. I have tried a few different solutions but so far no luck. Any suggestion welcome.
thanks in advance.