formula assistance help

New Contributor

Hi all I was hoping to get a little excel formula assistance, 

 

Imagine I have a list of employees in column A and their supervisors in column B. In column C i'd like the list of the supervisors supervisors. Since the supervisors are listed in column A i should be able to make a formula for this right? 

 

I have been googling and tinkering with formulas but am still unsuccessful. Heres is an example of something I tried: =INDEX(B2,(MATCH(B2,A:A,0)),1). Im trying to use a value in cell B2 to find value in A:A and return value in column B.

 

2 Replies

@daxmax9000 

 

Please try this:

=INDEX(B:B,MATCH(B2,A:A,0))
or
=XLOOKUP(B2,A:A,B:B)

@dscheikey  thanks for the reply! I tried this out and it doesnt quite work. I get mostly "#N/A"s but for some reason it looks like it works for 3 out of 130 supervisors.

 

I should mention that the names in both columns come from the same database so the names in column B should not differ from how they'd appear in Column A. I did test this by finding names from column B that came out as #NA and searching for that spelling in column A. They are matching. I also did use the clear the formatting tool on the whole document in case that was an issue.