Vlookup - how do I perform vlookup for the whole table instead of stopping at one row?

Help StudioX
,
1

The image shows an automation workflow using Excel, where a "For Each Excel Row" action iterates through rows in the "completed" sheet and performs a "VLookup" to find matching values in a specified range in the "vlookup" sheet. (Captioned by AI)
The image shows an automation workflow using Excel, where a "For Each Excel Row" action iterates through rows in the "completed" sheet and performs a "VLookup" to find matching values in a specified range in the "vlookup" sheet. (Captioned by AI)823×649 18.9 KB

Hi, how do I do vlookup to ensure each row is populated with the returns? please see attached for my screenshot. Thanks!

2

Hi @sparkestarx

Check the below thread

Regards,

3

Thanks. How do I rectify my current process instead?

4

Hi @sparkestarx

Can you try like below

The image depicts a sequence of a UiPath automation workflow that uses Excel activities to read rows from a sheet named "Completed," look up values from a sheet named "VlookUp," and save the results back to the "Completed" sheet. (Captioned by AI)
The image depicts a sequence of a UiPath automation workflow that uses Excel activities to read rows from a sheet named "Completed," look up values from a sheet named "VlookUp," and save the results back to the "Completed" sheet. (Captioned by AI)818×1380 58.3 KB

Input:

Completed Sheet

The image shows an Excel spreadsheet with columns for "Group Number" and "First Name," where the "Group Number" column is filled with numbers but the "First Name" column is empty, and there are tabs named "Completed" and "VlookUp" at the bottom. (Captioned by AI)
The image shows an Excel spreadsheet with columns for "Group Number" and "First Name," where the "Group Number" column is filled with numbers but the "First Name" column is empty, and there are tabs named "Completed" and "VlookUp" at the bottom. (Captioned by AI)361×759 6.91 KB

VlookUp Sheet

The image depicts an Excel spreadsheet with columns for Group Number, First Name, Last Name, and Group ID containing data for six individuals, organized under the "VLookUp" tab. (Captioned by AI)
The image depicts an Excel spreadsheet with columns for Group Number, First Name, Last Name, and Group ID containing data for six individuals, organized under the "VLookUp" tab. (Captioned by AI)390×735 7.74 KB

Output:

Completed Sheet

An Excel spreadsheet titled "Completed" lists group numbers alongside first names in columns A and B. (Captioned by AI)
An Excel spreadsheet titled "Completed" lists group numbers alongside first names in columns A and B. (Captioned by AI)358×747 7.34 KB

Regards,