Forum Discussion

daxmax9000's avatar
daxmax9000
Copper Contributor
Feb 10, 2023

formula assistance help

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 s...
excel
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Feb 10, 2023

daxmax9000 

 

Please try this:

=INDEX(B:B,MATCH(B2,A:A,0))
or
=XLOOKUP(B2,A:A,B:B)
daxmax9000's avatar
daxmax9000
Copper Contributor
Feb 10, 2023

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.

Resources