Find matching row in Column based on value in another column

[Dustinkli]

Good Day,


I am having a bit of trouble finding a solution to this one and I think that my main problem is that I don't know exactly what to search for. I’m sure that this question has been answered previously but I can’t see to find it after searching.


My issue is this:


I have a spreadsheet with servers and those are in Column E. In Column H I have the same Servers in a different order and in Column I I have the SubnetMasks of those Servers.
I’m trying to set it up so that Column F will match the server referenced in Columns H and I.



So for example


Column E Column F Column H Column I
Server 1 Server 2 Subnet B
Server 2 Server 3 Subnet A
Server 3 Server 1 Subnet C



I’m trying to match it up so that Column F has the Subnet for the respective servers in Column E by referencing what the subnet for that server is.



My goal:



Column E Column F Column H Column I
Server 1 Subnet C Server 2 Subnet B
Server 2 Subnet B Server 3 Subnet A
Server 3 Subnet A Server 1 Subnet C

 

[Fluff]

How about

Excel 2013/2016
	E	F	G	H	I	J
2	Server 1	Subnet C			Server 2	Subnet B
3	Server 2	Subnet B			Server 3	Subnet A
4	Server 3	Subnet A			Server 1	Subnet C
List

Cell Formulas
Range	Formula
F2	=INDEX($J$2:$J$4,MATCH(E2,$I$2:$I$4,0))