Lookup did not work


i am using the lookup through write cell which is not work
please anyone suggest what can i do

i am attaching the xaml & excel file for refe
data.xlsx (13.2 KB)
Main.xaml (10.7 KB)
rence and also create pivot table

Hello @lakshya_garg1

There seems to be an issue in inserting UiPath variables into Excel in your project.

In For Each Row activity you are using variable called cell. In Write Cell activity you are trying to refer to that variable:
Please note, that the value you are trying to input is a string (everything in quotes and in red color). Therefore cell is not treated as a variable, but as a string which is a part of a whole string “=VLOOKUP(cell,Sheet2!A:D,4,FALSE)”. If you want to treat cell as a variable, not as a string with value cell, you should concatenate value to be written into cell of 3 parts:

  1. beginning of the formula, which is VLOOKUP
  2. reference to cell value
  3. the rest of the vlookup formula

I hope this works for you :slight_smile:

Duplicate : Lookup did not worked - #3 by Lakshya_Garg

Duplicate of Lookup did not worked