Sheet1 of my workbook contains all my employee information. Sheet2 is where I assign those employees to certain assignments. In the assignments table, I have all the employees in lists in column B. I want to have their employee ID number automatically appear in column A, when I select the employee in column B. I have to get their ID Number from the employees information in Sheet1.
Use Index Match
Formula:
=INDEX(Sheet1!$A$4:$A$11,MATCH(Sheet2!B4,Sheet1!$B$4:$B$11,0))
or
xlookup
Formula:=XLOOKUP(B4,Sheet1!$B$4:$B$11,Sheet1!$A$4:$A$11,,0)
or
vlookup to the left
Formula:=VLOOKUP(B4,CHOOSE({1,2},Sheet1!$B$4:$B$11,Sheet1!$A$4:$A$11),2,0)
Last edited by alansidman; 10-02-2024 at 05:00 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks