INDEX COLLECT NAMES FROM 2 SHEETS TO ANOTHER SHEET

Bobby1

I HAVE (SHEET A) AND I NEED TO RETURN NAMES WHEN A MATCH OF IP ADDRESSES FROM SHEETS (DEL 1) AND (DEL 2) IS MADE.

Mike TV

@Bobby1

=IFERROR(INDEX({Del 1 Name Range}, MATCH(IP@row, {Del 1 Source IP Range}, 0)), IFERROR(INDEX({Del 2 Name Range}, MATCH(IP@row, {Del 2 Source IP Range}, 0)), "Match Not Found")

I believe this should work. It will search both sheets for a match and report the match or "Match Not Found" if the IP isn't on either sheet.

Bobby1

=IFERROR(INDEX({Del 1 smartsheet Range email}, MATCH(IP@row, {Del smartsheet Range 1}, 0)), IFERROR({{Del 2 smartsheet name1}}, MATCH(IP@row, {Del 2 smartsheet Range 1}, 0)), "MATCH NOT FOUND")

Mike TV

@Bobby1

You've got 2 {{ in there are the start of your 2nd IFERROR