Excel Look Up Range, Changing Range?

Help Studio
1

Hello, is there a way to use the excellookuprange activity but change the range to check every single row? For example, instead of putting “Range: B2:B100” could I set it to “Range: B2: B*” so it looks through every row? I am running a program where the number of rows constantly changes so sometimes it may be larger than 100. Thank you in advance.

2

Hi.
You can count the last row of excel.

2 Likes
3

You can Give range as “B:B”

3 Likes
4

Thank you so much!

5

Thank you very much!

6

Most Welcome!!

Happy Automation!