serial number and name list.

[dena]

I just cant figure this out. Any help is greatly appriciated.

Column A - random serial numbers, A has duplicates that need to stay in order.
Columns B and C are a known factual list of serial numbers of server names.
Column D I need the name of the server that matches the serial number in A.

IF A matches any C1:C4, put value of B(of the corresponding C) in D - the value in this example D (should be Server4)

012	Server1	123
789	Server2	456
123	Server3	789
	Server4	012

 

[GraH - Guido]

Maybe something like [D1]= INDEX(B:B , MATCH (A1, C:C , 0 ) )

 

[dena]

Maybe something like [D1]= INDEX(B:B , MATCH (A1, C:C , 0 ) )

Thank you so much. This worked for me.

 

[GraH - Guido]

My pleasure. Good to read it works for you.