Hello,
Having issues with index and Match for wrapped number in cell.
Using below formula and works fine for single ip in both input sheet and Data sheet.
=IF(ISNA(INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))),"",INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0)))
If single ip in sheet(input) unable to match, if main sheet(DATA) has multiple ip address wrapped in a cell.
Any help will be appreciated. Attached sample file
Having issues with index and Match for wrapped number in cell.
Using below formula and works fine for single ip in both input sheet and Data sheet.
=IF(ISNA(INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0))),"",INDEX(Data!$B$2:$B$10,MATCH(input!$A2,Data!$A$2:$A$10,0)))
If single ip in sheet(input) unable to match, if main sheet(DATA) has multiple ip address wrapped in a cell.
Any help will be appreciated. Attached sample file