LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default VLookup with multi-condition

I am doing a vlookup with regard to time keeping



A B C D

ID Date Time Status

0001 01/01/2010 7:25AM IN

0002 01/01/2010 8:12AM IN

0001 01/01/2010 5:15PM OUT

0002 01/01/2010 6:45PM OUT



I want to have an out put like





Date Time IN Time OUT

01/01/2010 7:25AM 5:15PM



Can anybody help me please.. Best regards,Anthony


Submitted via EggHeadCafe - Software Developer Portal of Choice
XCeed Streaming Compression Library
http://www.eggheadcafe.com/tutorials...compressi.aspx
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-condition SUMIF Manuel Excel Worksheet Functions 4 December 10th 09 01:49 PM
Complex Multi-condition, multi-workbook count Heliocracy Excel Discussion (Misc queries) 0 October 4th 07 08:18 PM
Rank by Multi Condition Ananth Excel Discussion (Misc queries) 4 June 26th 07 06:01 AM
Help with Multi-Condition Formula VB Excel Worksheet Functions 2 February 28th 07 08:58 PM
Multi-condition vlookup Hobbeson Excel Worksheet Functions 4 July 19th 05 02:57 AM


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"