rong3
10-02-2017, 12:57 AM
Hello, I am struggling with the VLOOKUP function, I have written code like this
Application.WorksheetFunction.VLookup(input_value, ThisWorkbook.Sheets(sheetname).Range(range_), Pos, 0)
Which input_value on Column B and want to get value of Column A. But it can not. Hope the help of you. Thanks so much.
20541
Application.WorksheetFunction.VLookup(input_value, ThisWorkbook.Sheets(sheetname).Range(range_), Pos, 0)
Which input_value on Column B and want to get value of Column A. But it can not. Hope the help of you. Thanks so much.
20541