Excel Lookup Range - Entire Worksheet

Help
1

Hi, I need to find a cell with a specific value in the entire worksheet. How do I do this with the Excel Lookup Range activity? Esp. since specifying the range beforehand will limit the search area or cause it to search an unnecessarily wide area

2

What do you intend to do with that value? you could export the entire table as a string and search for the value that way if you only intend to know, True or False, if it exists.

Otherwise you use dynamic ranges within a do while loop and once the value is encountered the cell reference can be returned and the search halted.

3

@ronanpeter With the address index I can find the start of a table, which is always found next to that cell

4

This should help though there may be a better way to do it without the column array.

It uses the Lookup Range activity across the whole excel file looking for a certain value and gets the cell reference. Then, using the below code and an array of excel column references {A, B, C,…}, it will create a Target Cell Reference for you to identify where your table starts.

TargetCell = (arrColumns((Convert.ToInt32(Array.IndexOf(arrColumns, Left(OutputRef, 1)).ToString))+1)) + (Right(OutputRef, 1).ToString)

FindValueCellRef.zip (7.9 KB)

5

this file seems corrupted, can yo uplease reshare it!!

many thanks

6

Sure. It may be corrupted due to Studio version or packages requiring updates.

FindValueCellRef.zip (8.2 KB)

7

It takes forever to load, any suggestions

8

what takes an age to load? it runs in about 10seconds for me

9

This an example which may be helpful: UiPath Tutorial | Uipath Lookup Range Practice - YouTube

10

why I’m getting error at “CellIndexValue” , any package should i import?