LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MFM MFM is offline
external usenet poster
 
Posts: 10
Default Lookup by multiple criteria.

I need to look up dept by date and emp #. Please see c15. Thanks

A B C
1 Date Emp # Dept
2 5/1/2007 A1054 Sales
3 6/1/2007 B1074 Prod
4 7/1/2007 C2074 Fin
5 8/1/2007 D1085 Sales
6 9/1/2007 e7805 Fin
7 10/2/2007 f8091 Prod
8 11/2/2007 g9071 Sales
9 12/3/2007 g7081 Prod
10 1/3/2008 h9081 Fin
11 2/3/2008 i70550 Sales
12 3/5/2008 j75520 Sales
13
14 Date Emp # DEPT
15 5/1/2007 A1054 =if(vlookup(A15,a2:c12,3)=b15,c,?
16 6/1/2007 B1074
17 7/1/2007 C2074
18 8/1/2007 D1085
19 9/1/2007 e7805
20 10/2/2007 f8091
21 11/2/2007 g9071
22 12/3/2007 g7081
23 1/3/2008 h9081
24 2/3/2008 i70550
25 3/5/2008 j75520

 
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
Lookup using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo Excel Worksheet Functions 4 January 16th 07 03:21 AM
Lookup using multiple sheets and multiple criteria kjguillermo Excel Discussion (Misc queries) 2 January 14th 07 10:28 AM
Lookup on multiple criteria and max jeffbert Excel Worksheet Functions 2 October 12th 06 06:33 PM
Lookup with multiple criteria... please help! Anna Excel Worksheet Functions 3 July 19th 06 09:59 PM
LookUp with multiple criteria mike47338 Excel Worksheet Functions 2 February 20th 06 11:42 PM


All times are GMT +1. The time now is 01:27 AM.

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"