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.