cancel
Showing results for 
Search instead for 
Did you mean: 

Search excel cell value

NiteshGoyal
Level 3
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

YogitaKulkarni
Level 3
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