Forum Discussion
Solved
Find Which Emp Number is Associated with Which Person in a Data Set
Good Day!
I'm unsure which formula to use, I have a data set that shows First Name, Last Name, Emp Number, and Dates Attended that is auto generated by who shows up in any particular day. (See attached Pic#1)
I would like a formula that breaks down which names are associated to each number. So, for example if I type in '6167' into a cell it will show 'Tom Rock' is associated with that number. (See attached Pic #2)
Let's say the first dataset is on a sheet named Sheet 1, in columns A to D.
The cell in which you enter the number to search for is on another sheet in A2.
In B2:
=XLOOKUP(A2, 'Sheet 1'!$C$2:$C$1000, 'Sheet 1'!$A$2:$B$1000, "")
The result will spill to B2:C2.
Let's say the first dataset is on a sheet named Sheet 1, in columns A to D.
The cell in which you enter the number to search for is on another sheet in A2.
In B2:
=XLOOKUP(A2, 'Sheet 1'!$C$2:$C$1000, 'Sheet 1'!$A$2:$B$1000, "")
The result will spill to B2:C2.