My formula from google sheets is below. By pasting it in to Zoho, it does not work. If I try to rebuild it in Zoho I get stuck when I try to select multiple columns for either the Index or Match functions. Is this not an available function? Am I not using the proper modifier key on my (Mac) keyboard to select more than one column?

1. =IFERROR(INDEX({NetworkSwitches!$B$5:$B;NetworkSwitches!$H$5:$H;NetworkSwitches!$N$5:$N;NetworkSwitches!$V$5:$V},MATCH(B2{NetworkSwitches!$A$5:$A;NetworkSwitches!$G$5:$G;NetworkSwitches!$M$5:$M;NetworkSwitches!$S$5:$S},0)))

Rough example below of what I'm trying to do. Let me know if you have a smarter formula.

I have one sheet where I list equipment (A) based on IP address (B). On another sheet I enter the names of the equipment (A) based on the port they're plugged in to on a network switch (C). Back on the first sheet, there's a cell with a formula that displays the switch port number (C).

In practice, there's a list of up to 250 devices and at least 4 switches with at least 28 ports each. I use a version of this formula for many other places I need data filled in in the same workbook.

SHEET ONE

A	B	C
apple	192.168.1.1
orange	192.168.1.2
pear	192.168.1.3
banana	192.168.1.4

SHEET TWO

A	C
pear	1
banana	2
apple	3
orange	4