if the four param in excel app’s vlookup function are → Lookup_value: [@[FTA cert reference]], Table_array: [abc.xlsx]Table!$AI:$AJ, Col_index_num: 2, Range_lookup:0, how can we attain the vlookup function by using robocorp? Note that the Lookup_value was taken from testexcel.xlsx, and the Table_array was taken from abc.xlsx (just an example, what i want to say is the table_array was taken from another excel file). How can we write the code?
You can read your excel files to tables and perform any searches or filtering by using RPA.Table keyords