Excel Search and add Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1524666%22%20slang%3D%22en-US%22%3EExcel%20Search%20and%20add%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524666%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%20can%20someone%20assist%20me%20in%20creating%20a%20function%20that%20searches%20one%20column%20for%20multiple%20IP%20addresses%20that%20are%20already%20added%20and%20if%20not%20present%20add%20it%20in%20the%20same%20format%3F%20Please%20and%20I%20really%20appreciate%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20of%20these%20tables%20are%20on%20different%20sheets.%20Basically%20I%20need%20the%20same%20for%20both%20IP%20addresses%20and%20the%20services.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1524666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524956%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Search%20and%20add%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524956%22%20slang%3D%22en-US%22%3Ewhere%20should%20it%20look%20for%20what%20and%20where%20to%20add%20it%3F%20...%20which%20columns%20or%20cells%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526649%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Search%20and%20add%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Bhello%20thanks%20for%20the%20help.%20Need%20it%20to%20search%20column%20A%20and%20add%20the%20new%20IP%20address%20with%20a%20similar%20format%20in%20the%20next%20blank%20row%20for%20instance%20row%2010%20in%20this%20case%20if%20you%20look%20at%20my%20sheet%20or%20row%2021%20for%20services.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20instance%2C%20look%20for%20IPs%20172.16.1.10%20and%26nbsp%3B172.27.240.2%20and%20if%20172.16.1.10%20is%20not%20found%20add%20it%20to%20row%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221238%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22208%22%3EOBJ_172.16.1.10-32%3C%2FTD%3E%3CTD%20width%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Eipmask%3C%2FTD%3E%3CTD%20width%3D%2267%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Eenable%3C%2FTD%3E%3CTD%20width%3D%22142%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2294%22%3Edisable%3C%2FTD%3E%3CTD%20width%3D%22208%22%3E172.16.1.10%20255.255.255.255%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2236%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20if%20172.27.240.2%20is%20found%20do%20nothing%20about%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

hello, can someone assist me in creating a function that searches one column for multiple IP addresses that are already added and if not present add it in the same format? Please and I really appreciate it. 

 

Each of these tables are on different sheets. Basically I need the same for both IP addresses and the services.

2 Replies
where should it look for what and where to add it? ... which columns or cells

@Nikolino hello thanks for the help. Need it to search column A and add the new IP address with a similar format in the next blank row for instance row 10 in this case if you look at my sheet or row 21 for services. 

 

So for instance, look for IPs 172.16.1.10 and 172.27.240.2 and if 172.16.1.10 is not found add it to row 10

 

OBJ_172.16.1.10-32 ipmask enable 0disable172.16.1.10 255.255.255.255     

 

and if 172.27.240.2 is found do nothing about it.