Trying to look for formula for searching through Range and search through Data to achieve expected res
Data Output Expected Range
Pune 123 is city Pune 123 Mumbai 999
Maharashtra 345 is state Maharashtra 345 Pune 123
India 678 is Country India 678 Nagpur 666
Maharashtra 666 is state Others Pune 555
Below is the query i used for manual search however need formula to see through Range and achieve output expected
=IF(ISNUMBER(SEARCH("Pune 123",A5)),C5,
IF(ISNUMBER(SEARCH("Maharashtra 345",A6)),C6,
IF(ISNUMBER(SEARCH("India 678",A7)),C7,"Others")))
Bookmarks