#1
|
|||
|
|||
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)) |
#2
|
||||
|
||||
In C1 enter =VLOOKUP($B$1,$A$4:$D$26,COLUMN()-1,FALSE) and drag right to columns C and D
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks a lot. I highly appreciate this great support.
|
#4
|
||||
|
||||
Welcome - You can indicate the thread solved with the Thread Tools drop down
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |