To perform VLookup for a range of data without using 'for each excel row' activity

Learn Academy Feedback
1

Continuing the discussion from VoolUp in Modern Activities:

Anyone knows how to perform VLookup for a range of data using modern (new) excel activities, without using ‘for each excel row’ activity? Thanks in advance!

2

use copy paste range and you can copy paste your formulae too

3

How do I copy the formula? Because I am using the VLookup activity hence only the value is shown for the first cell… it will only copy and paste the same value (first cell value) throughout the column