|
|
#1
08-05-2014, 04:06 PM
|
|||
|
|||
VLook up search
Hi, On one tab the cell contains a text string that includes the unique id number is within quotes (i.e. Employee number "12345" failed skills test). On another tab there is a listing of all employee numbers in one column with first and last names in separate columns. Can a Vlookup search the text for the first set of quotes, and match it to information on the second tab?
Tab 1 Column A, cell 2 Employee number "12345" belongs to department 19. Tab 2 Column A, cell 2 12345 Column B, cell 2 Lname Column C, cell 2 Fname Column D, cell 2 Location 
|
| Tags |
| vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
| Looking for Windows Search app with ability to search by content | gopher_everett | Office | 1 | 02-28-2013 09:23 PM |
 AND/OR/NOT-search
|
joblo108 | Excel | 3 | 09-09-2011 04:23 AM |
| Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |
| Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |
Windows 7 32bit 
Office 2007
Threaded Mode