# Read corresponding cell value in excel **URL:** \ **Category:** Studio\ **Tags:** datatable, studio, excel, activities\ **Created:** [February 3, 2022, 10:52am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492 "2022-02-03T10:52:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kavya.s16](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kavya.s16/32/263386_2.png) [@kavya.s16](https://forum.uipath.com/u/kavya.s16)\ **Post date:** [February 3, 2022, 10:52am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/1 "2022-02-03T10:52:17Z")
Hi Everyone I have an excel with different sheets , My requirement 1. Need to read a sheet named “circulation” in that excel 2.which has many columns 2. It has cell in middle (not constant) named “cc list” , i need to read the value opposite to it eg : at E6 i have “cc list” , i need to get value corresponding cell i.e., next cell F6 ---
**Author:** ![Srini84](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/srini84/32/464032_2.png) [@Srini84](https://forum.uipath.com/u/Srini84)\ **Post date:** [February 3, 2022, 11:01am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/2 "2022-02-03T11:01:05Z")
@kavya.s16 Use Get cell Value activity to read the cell value Thanks ---
**Author:** ![Gokul001](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/gokul001/32/462734_2.png) [@Gokul001](https://forum.uipath.com/u/Gokul001)\ **Post date:** [February 3, 2022, 11:02am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/3 "2022-02-03T11:02:58Z")
Hi @kavya.s16 Use the Excel scope application Activity → Give the Excel path Read range Activity → Sheet name → “circulation” , Store the value in the Data Table. For each row DataTable Activity loop through the excel. If Condition Row(“column Name”).Tostring.Contains(“CC”) Then Row(“Target Column”).tostring Or Use Get cell Value activity Hope it will help you Regards Gokul ---
**Author:** ![pravin\_calvin](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pravin_calvin/32/212149_2.png) [@pravin\_calvin](https://forum.uipath.com/u/pravin_calvin)\ **Post date:** [February 3, 2022, 11:03am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/4 "2022-02-03T11:03:24Z")
Hi @kavya.s16 You can achieve it with below steps Read range the datatable For each row in readdt If current row of current row(“yourcolumnname”).roaring.equals(“your stringvalue”) Then part print currentrow (“your target column”).ToString Regards ---
**Author:** ![THIRU\_NANI](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/thiru_nani/32/317561_2.png) [@THIRU\_NANI](https://forum.uipath.com/u/THIRU_NANI)\ **Post date:** [February 3, 2022, 11:05am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/5 "2022-02-03T11:05:19Z")
Hi! After reading the sheet use for each row in data table and take one if condition **CurrentRow(“circulation”).ToString = (“cc list”) And CurrentRow(“circulation”).ToString=CurrentRow(“F\_ColumnName”).ToString** use read cell activity to read the particular cell. Regards, NaNi ---
**Author:** ![Shikhar\_Tandon](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shikhar_tandon/32/176817_2.png) [@Shikhar\_Tandon](https://forum.uipath.com/u/Shikhar_Tandon)\ **Post date:** [February 3, 2022, 11:20am UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/6 "2022-02-03T11:20:08Z")
Hi @kavya.s16 , Is the value cc list under any specific column? as you mentioned it is not constant. Thanks ---
**Author:** ![kirankumar.mahanthi1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kirankumar.mahanthi1/32/322620_2.png) [@kirankumar.mahanthi1](https://forum.uipath.com/u/kirankumar.mahanthi1)\ **Post date:** [February 3, 2022, 12:22pm UTC](https://forum.uipath.com/t/read-corresponding-cell-value-in-excel/396492/7 "2022-02-03T12:22:08Z")
Hi @kavya.s16 , Use work book read range to read the whole excel content in data table. As per your post value “cc list” can be anywhere in the excel so we can go for lookup range activity in uipath here assign your test string “cc list” it will give you the result of cell reference. For suppose we have received cell reference value E6. We can use matches activity to divide the number from character and increment the character by using the following function Convert.ToChar(Convert.ToUInt16(InputCharacter) +1) so that you will get next value F6. i hope the above might helpful for your requirement. thanks. ![image](https://global.discourse-cdn.com/uipath/original/4X/2/d/d/2dd29284726eb2abaf573957a00e016e9d8870ef.png) [FindtheNextvalueforInputString.zip](https://forum.uipath.com/uploads/short-url/l4CDtolqAs4kCsKtUNbnWtLLPxN.zip) (9.1 KB)