Vlookup not working

Help Studio
, ,
1

hi team,
i am trying to get data from one excel sheet and paste that into another sheet by using vlookup(modern) activity but i am getting null values and in my sheet at least two invoices numbers are matched.plz anyone help me …

The image shows a workflow in an automation software for accessing and using two Excel files named "ZVR03-not INV.xlsx" and "ZVR07.xlsx" from the user's downloads folder, with options to save changes and create the files if they do not exist. (Captioned by AI)
The image shows a workflow in an automation software for accessing and using two Excel files named "ZVR03-not INV.xlsx" and "ZVR07.xlsx" from the user's downloads folder, with options to save changes and create the files if they do not exist. (Captioned by AI)612×475 16.1 KB

The image depicts an Excel process automation workflow using a VLookup function to match values from one sheet to another and save the results. (Captioned by AI)
The image depicts an Excel process automation workflow using a VLookup function to match values from one sheet to another and save the results. (Captioned by AI)496×481 18.1 KB

2

Hi ,

Is the matching column in the second file starts from Column A only??

While doing the vlookup - the range should start with the matching column only. Kindly confirm the same

Also i have created a sample project for your reference where a file will do the vlookup from another file. Code is tested and working fine

Steps to note are:

  • Open the destination file first
  • Then the Source File
  • Do the looping of Destination file inside the source file
  • Apply Vlookup

image
image896×1791 80.1 KB

ForumTest (2).zip (538.5 KB)

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.