Hi,
Would like to seek a solution to identify which hostname with given IP address. But the specific IP address is in a string of IPs in a Cell.
Kindly find the example in attached excel
Thank you.
Hi,
Would like to seek a solution to identify which hostname with given IP address. But the specific IP address is in a string of IPs in a Cell.
Kindly find the example in attached excel
Thank you.
Try:Formula:=IF(A12="","",INDEX($A$3:$A$5,MATCH("*"&A12&"*",$B$3:$B$5,0)))
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
One way, please try in B12 and copy down:and try in C12 and copy down:Formula:=INDEX(A$3:A$5,MATCH("*"&A12&"*",B$3:B$5,0))Formula:=INDEX(C$3:C$5,MATCH("*"&A12&"*",B$3:B$5,0))
maybe Power Query
IP address Given Host 10.16.123.423 Hostname1 13.122.77.45 Hostname2
Thank you all for the speedy solution. It's saves my work in searching for the IP address.
You are welcome
Have a nice day
You are welcome, thanks for the fedback and rep .
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks