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 attac...
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.