Hello All,
I have this macro code:
I would like to simplify it to no longer use the R1C1 syntax. I'd like to do something similar to the following:
That code doesn't work, of course, and it also doesn't include the ISNA portion. I'd like to have the variable hold the TRUE or FALSE result of the ISNA.
The first part of the VLOOKUP is a concatenated value, with a hyphen between the values, such as 10-223. I need to lookup data in Column C on the Lookup sheet in the Helper File. Any ideas?
I have this macro code:
Code:
Cells(i, 27).FormulaR1C1 = "=ISNA(VLOOKUP(RC[-23]&""-""&RC[-19], '[Helper File.xls]Lookup'!C1:C1,1,0))"
Code:
VariableName = Application.WorksheetFunction.VLookup(Range(Cells(i, 3)).Value & "-" & Range(Cells(i, 13)).Value, '[Helper File.xls]Lookup'!C1:C1, 1, True)
The first part of the VLOOKUP is a concatenated value, with a hyphen between the values, such as 10-223. I need to lookup data in Column C on the Lookup sheet in the Helper File. Any ideas?