Variable Vlookup with Do-While loop <<URGENT! :(>>

and also, it would be extremely splendid if you can share Auto-fill range’s example too

Its writing in the same row everytime? Can you post the screenshot inside the while loop.

Auto fill range is very easy to use, please drag that try it and let me know if you have doubts, so that I can help you on that

![image|432x500](upload://bjOzVcGyUOxlz36wIqlOfWcYZY0.png
i will try using it,

Everything is looking good here, do one thing,

use for each row loop and leaving all these aside, loop through Check1 and inside that, use excel application scope and write cell.

on it

should formula now be changed to

“=IF(VLOOKUP(”+a+“,[fff.xlsx]SQLExport!$B$2:$B$32075,1,0)=”+a+“,1,0)”

where a = row(0).Tostring

…im so confused right now…

Formula won’t change., even you don’t need to pass the dynamic values also, but just leave it as it is. So if you are getting the right value for A2, then start with auto fill range

can you please please give me an example of auto fill range…literature isnt very sufficient

Documentation is available for that, you can check that as well

Here is the screenshot of how auto fill range needs to be used

  1. source range is what value or formula you need to write for entire rows (Existing value)
  2. Destination range is the count of rows you want to write the data to or the formula you want to drag to

image

on it

its failing

made it work
in write cell added ‘1’

from “B”+(Val).ToString
to “B”+(Val+1).ToString

thank you @hareeshMR for your constant and dilligent support. Grateful

it now works like a dream, for anyone interested

for_uipath_rolling_vlookup_.xaml (18.7 KB)

it would be extremely splendid if you can share Auto-fill range’s example too

well I wanted to ask the same thing…

dude check this, made it work

image