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...