|
|
#1
01-09-2012, 11:45 PM
|
|||
|
|||
Return Entire Row
In B1 the user will select the department name from a drop down list then Vlookup code will take this name and search in columns A & B to find the organization code corresponding to this Department name.
This code working fine but I want also to return information that belong to the same department name that located in same row of column C & D. Is there any function that can do this? I appreciate your help. Code:
=(VLOOKUP(B1,A4:B26,2,FALSE)) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
 Password entire application?
|
markg2 | Office | 4 | 05-10-2011 05:15 AM |
| Moving Entire Text | Sleeper | Word | 2 | 01-10-2010 04:40 PM |
| WORD taking up entire CPU!!! | pureride | Word | 0 | 03-28-2008 09:46 AM |
| Entire Document Changes Bold or Justification | buns_1 | Word | 0 | 05-03-2006 01:04 PM |
Windows Vista 
Office 2007
Threaded Mode