I'm trying to verify account setups for a list of people.
I'm trying the following vLookup forumla in cell A3...
workbook1
workbook2
So, I'm trying to tell it to use the value of column E in "workbook1", to find the same value in the array of "workbook2", and return the value of column 1 for that record/row in "workbook2", back to column 1 in "workbook1".
Am I making sense? Unfortunately, I am either getting "#N/A" or the value of column 1 in "workook2" for the last record in the array (regardless of last name match). And yes, the name is the full name in "workboo2", so I'm hoping this will find the last name even so.
- In one workbook ("workbook1"), we have the list of users by name.
- In another workbook ("workbook2"), we have users listed by name, and...
their records also includes a User ID column with values like "abcd123" (4 alpha characters and 3 numeric).
I'm trying the following vLookup forumla in cell A3...
Excel Formula:
=VLOOKUP(E3,'https://users/dbe4876/Documents/[workbook2]sheet1'!$B:$O,1)
workbook1
User ID | Business Unit | Employee's First Name | Employee's Middle Name or Middle Initial | Employee's Last Name |
#N/A | Sales | John | A | Doe |
abcz999 | Marketing | Jill | A | Doedoe |
workbook2
User ID | Initials | Assign To |
abcd123 | JAD | Jill Doedoe |
abce234 | JAD | John Doe |
So, I'm trying to tell it to use the value of column E in "workbook1", to find the same value in the array of "workbook2", and return the value of column 1 for that record/row in "workbook2", back to column 1 in "workbook1".
Am I making sense? Unfortunately, I am either getting "#N/A" or the value of column 1 in "workook2" for the last record in the array (regardless of last name match). And yes, the name is the full name in "workboo2", so I'm hoping this will find the last name even so.