| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up march and copy info back - Help! confused!!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia | Excel Discussion (Misc queries) | |||
| 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia | Excel Worksheet Functions | |||
| 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia | Excel Worksheet Functions | |||
| 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia | Excel Discussion (Misc queries) | |||
| 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia | Excel Worksheet Functions | |||
Threaded Mode
