S
Seantastic
I have a spreadsheet with 2 tabs.
First tab is named “inventory†and has a list of “computer names†in column
“A†(from row 2 to 8729) the user “First Name†in column “I†and the users
“Last Name†in column “Jâ€.
There is no particular order in this list and the names are in some random
order.
My second tab is named “Users†and has a list of the user “First Name†in
column “B†and the users “Last Name†in column “Câ€. Column “A†is blank.
There is no particular order in this list and the names are in random order.
I want excel to take the First Name and Last Name that are in the “Usersâ€
tab look it up (match) the Same First and Last Name in the “inventory†and
copy the associate “computer name†from Column “A†back into the blank column
“A†of my “Users†tab.
I tried this functions =VLOOKUP(C2;Inventory!J2:K8729;2)
but the problem I got was
1) It only looked at Last Names (and I have a few Smiths)
2) When it encountered blank spaces in tab “inventory†in would not continue
lower
3) Did not go through all the list in tab “inventoryâ€
4) Did not work – I do not really know what I am doing!!
vvvv
First tab is named “inventory†and has a list of “computer names†in column
“A†(from row 2 to 8729) the user “First Name†in column “I†and the users
“Last Name†in column “Jâ€.
There is no particular order in this list and the names are in some random
order.
My second tab is named “Users†and has a list of the user “First Name†in
column “B†and the users “Last Name†in column “Câ€. Column “A†is blank.
There is no particular order in this list and the names are in random order.
I want excel to take the First Name and Last Name that are in the “Usersâ€
tab look it up (match) the Same First and Last Name in the “inventory†and
copy the associate “computer name†from Column “A†back into the blank column
“A†of my “Users†tab.
I tried this functions =VLOOKUP(C2;Inventory!J2:K8729;2)
but the problem I got was
1) It only looked at Last Names (and I have a few Smiths)
2) When it encountered blank spaces in tab “inventory†in would not continue
lower
3) Did not go through all the list in tab “inventoryâ€
4) Did not work – I do not really know what I am doing!!
vvvv