Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 06-26-2009, 03:23 PM
NV32 NV32 is offline
Registered User
 
Join Date: 26 Jun 2009
Location: Tampa
MS Office Version:Excel 2003
Posts: 2
NV32 is becoming part of the community
if or vlookup help (combined columns or rows in one)

Please Register to Remove these Ads

Help with vlookup, if ....

--------------------------------------------------------------------------------

I need help w excel.
how i can combined several columns in other sheet if the person meet the criteria.

exampe (each number is separate column) first sheet
1. Maria Rodriguez
2. Start date
3. term date
4. 90 days


second sheet
i want pull with a formula all the employees that have been terminate over 90 days and i want to pull their name, start date, term date and let me know if meet the require 90 days only
like: Maria Rodriguez - start date - term date - 90 days (all in one row)
Reply With Quote
  #2  
Old 07-03-2009, 06:55 AM
mubashir aziz's Avatar
mubashir aziz mubashir aziz is offline
Valued Forum Contributor
 
Join Date: 18 Mar 2009
Location: Lahore, Pakistan
MS Office Version:Excel 2003
Posts: 453
mubashir aziz has an addiction to Excel
Re: if or vlookup help (combined columns or rows in one)

Sample sheet with data and example will be helpful for others to solve your problem ..................
__________________
If this post helps, Please don't 4get to add to My reputation by clicking BluScale Icon in the Top Right Corner of Blue Bar of my Post.
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump