Find Hostname and Application from a list of IP address from Merged Cell

Hi,

I have a raw data of IP address with includes (), /, : and words in a merged cells.
Would like to find out the hostname and application name where the IP address is in single address and check against the merge cells.

For better understanding, please refer to attached file.

Would appreciate your assistance on how to solve this issue. Thank you.

Hi no file attached.

Please upload

Hi

Attached is the sample data for your understanding. Thank you.

Hi,

Really need your assistance to extract the IP addresses from the merged cells. Thank you.

Or try this ...

=VLOOKUP("*"&$A12&"*",$A$3:$C$7,COLUMNS($A:B),0)

Copy cross and down.

That's awesome. Both formulas worked.
Thank you FlameRetired and Phuocam.