https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62005#M15195 I have a excel with around 500 rows. Columns are not fixed one can have 1, 10. Cell value can be anywhere in the excel. I want to get a value of cell adjacent to some text value. Cell No Value O30 Customer Type P30 C123456 So I need to search "Customer Type" and then want to retrieve value "C123456" Please suggest a way to do this. Mon, 28 Nov 2016 21:14:00 GMT NiteshGoyal 2016-11-28T21:14:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62005#M15195 I have a excel with around 500 rows. Columns are not fixed one can have 1, 10. Cell value can be anywhere in the excel. I want to get a value of cell adjacent to some text value. Cell No Value O30 Customer Type P30 C123456 So I need to search "Customer Type" and then want to retrieve value "C123456" Please suggest a way to do this. Mon, 28 Nov 2016 21:14:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62005#M15195 NiteshGoyal 2016-11-28T21:14:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62006#M15196 Hi nitesh.b.goyal, You have two choices how to proceed. 1)You can build this with MS Excel VBO - it will have all the necessary Actions to deal with your task (such as go to next cell,Go to next empty cell,copy,etc..). 2)You can create a code stage to deal with this (performance wise this would be faster) Fri, 02 Dec 2016 14:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62006#M15196 Anonymous 2016-12-02T14:21:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62007#M15197 Hi Nitesh, I am using the same functionality and I split it up in two phases: 1) 'find cell based on value' in the MS excel VBO 2) I created a function myself withing the MS excel VBO called 'Offset Active Cell', based on some code: Dim Instance As Object = GetInstance(handle) Instance.ActiveCell.offset(Row_Offset,Column_Offset).activate In the inputs, you need handle (number), workbook (text), Row offset & Column offset. Make sure you also have data items for all these data I hope this helps Fri, 02 Dec 2016 19:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62007#M15197 matthias_vander 2016-12-02T19:51:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62008#M15198 I don't have 'find cell based on value' in my MS excel VBO. Where did you get that? Sounds pretty useful. Sat, 03 Dec 2016 05:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62008#M15198 CynthiaLibby 2016-12-03T05:01:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62009#M15199 I am also not able to find the 'find cell based on value' in my MS excel VBO. Please tell where I can find? ? Tue, 06 Dec 2016 22:23:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62009#M15199 NiteshGoyal 2016-12-06T22:23:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62010#M15200 Hi Matthiasvg, I am not able to find the 'find cell based on value' in my MS excel VBO. Please tell where I can find? Tue, 06 Dec 2016 22:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62010#M15200 NiteshGoyal 2016-12-06T22:25:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62011#M15201 You can use this code to create that function. It will look for the value and activate it: Dim wb As Object wb = GetWorkbook(Handle, Workbook) wb.activesheet.Cells.Find(What:=Cell_value).Activate You need the handle, workbook and cell value as inputs Wed, 07 Dec 2016 15:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62011#M15201 matthias_vander 2016-12-07T15:51:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62012#M15202 @Matthiasvg i have tried the above code but it shows the below error: Internal : Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary. Could please guide me how to proceed writing the code in an new object studio as we use in Excel VBA to intract with excel. Thu, 08 Dec 2016 08:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62012#M15202 Vijaya_KumarA 2016-12-08T08:37:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62013#M15203 @Matthiasvg i have tried the above code but it shows the below error: Internal : Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary. Could please guide me how to proceed writing the code in an new object studio as we use in Excel VBA to intract with excel. Fri, 09 Dec 2016 11:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62013#M15203 Vijaya_KumarA 2016-12-09T11:27:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62014#M15204 Works great! thanks for the share! Tue, 24 Jan 2017 08:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62014#M15204 Juan_EstebanLóp 2017-01-24T08:30:00Z https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62015#M15205 Hi Matthiasvg/Juan.Lopez,   I am getting the error  ""Internal : Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary."" for above code.  Could you please help Sun, 21 Jan 2018 18:58:00 GMT https://community.blueprism.com/t5/Product-Forum/Search-excel-cell-value/m-p/62015#M15205 YogitaKulkarni 2018-01-21T18:58:00Z