I am having an issue while trying to implement vlookup activity into my robot. I have an excel file with 2 columns: 1st column contains dates and 2nd column contains random text. I need to go through the column 2, which should contain text like “text1” or/and “text2” and the rest can be anything. My goal is to get the value from column 1 which is date. In the case if lookup value is “text1” OR “text2” it is easy to get the correct date as all I need is to select data table, lookup value which is f.e. “text1” and select column 2 in target column and create an output value. Now in my case it is something like this:
As I am interested only in the date which is most recent and stands in front of Text1 or Text2 (doesn’t matter which one), what should my lookup value look like? I would like to use something like (“Text1” or “Text2”) but obviously it is not correct. Any suggestions would be really helpful.