Search excel cell value
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-11-16 09:14 PM
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.
10 REPLIES 10
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-01-18 06:58 PM
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

- « Previous
-
- 1
- 2
- Next »