I am trapped in look up data table

Help Activities
, , ,
1

I want to search for today’s date from excel file and return the cell right next to it. But I feel it difficult to go through because all that I find in youtube is run by old version. Can anyone help me figure out with latest version?

vlookup excel mail

1 Like
2

Hi @kjy03171
Welcome to UiPath,
You can try below method:

  1. Use Excel File
  2. Read Range → output dtExcel (DataTable)
  3. For Each Row in Data Table
  4. If condition → row("DateColumn").ToString.Contains(Now.ToString("dd/MM/yyyy"))
  5. Assign → result = row("NextColumn").ToString

happy automation

3

Hi @kjy03171

image
image667×381 20.6 KB

  • Range – The column where the value you want to search exists (Lookup column).
  • Source of results – The column from which you want to retrieve the output value.
  • Value to lookup – The value you want to search for (in your case, the Date).

Hope this helps :slight_smile:

4

Hi @kjy03171

You can also try this if you want the cell index

image
image419×444 14.4 KB

CellValue = Chr(Asc(index.Substring(0,1)) + 1).ToString + index.Substring(1)

Hope this helps!