![]() |
#1
|
|||
|
|||
![]() 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)) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
![]() |
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 |