Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-09-2012, 11:45 PM
ibrahimaa ibrahimaa is offline Return Entire Row Windows Vista Return Entire Row Office 2007
Advanced Beginner
Return Entire Row
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Unhappy 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))
Attached Files
File Type: xlsx Return Entire Row.xlsx (18.4 KB, 25 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS calculation for entire column Salient Excel 0 07-11-2011 03:58 PM
Return Entire Row 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft