| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup or Vlookup?
A B C D E F G
Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or Vlookup?
What result do you expect, there are 2 dates when 12 was drawn.
-- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... A B C D E F G Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or Vlookup?
I'm sorry, I meant to say the most RECENT date chosen.
Col A = the number of the drawing Col B = the date Cols C to G = the 5 picks "T. Valko" wrote: What result do you expect, there are 2 dates when 12 was drawn. -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... A B C D E F G Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or Vlookup?
Try this array formula** :
=IF(COUNTIF(C2:G6,12),MAX(IF(C2:G6=12,B2:B6)),"not drawn") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Format as Date -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... I'm sorry, I meant to say the most RECENT date chosen. Col A = the number of the drawing Col B = the date Cols C to G = the 5 picks "T. Valko" wrote: What result do you expect, there are 2 dates when 12 was drawn. -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... A B C D E F G Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or Vlookup?
I wish that I could comprehend exactly what is going on here but this works
perfectly! You are the man! Thanks so much! "T. Valko" wrote: Try this array formula** : =IF(COUNTIF(C2:G6,12),MAX(IF(C2:G6=12,B2:B6)),"not drawn") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Format as Date -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... I'm sorry, I meant to say the most RECENT date chosen. Col A = the number of the drawing Col B = the date Cols C to G = the 5 picks "T. Valko" wrote: What result do you expect, there are 2 dates when 12 was drawn. -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... A B C D E F G Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or Vlookup?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... I wish that I could comprehend exactly what is going on here but this works perfectly! You are the man! Thanks so much! "T. Valko" wrote: Try this array formula** : =IF(COUNTIF(C2:G6,12),MAX(IF(C2:G6=12,B2:B6)),"not drawn") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Format as Date -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... I'm sorry, I meant to say the most RECENT date chosen. Col A = the number of the drawing Col B = the date Cols C to G = the 5 picks "T. Valko" wrote: What result do you expect, there are 2 dates when 12 was drawn. -- Biff Microsoft Excel MVP "PJ Murph" wrote in message ... A B C D E F G Drawing # Date PICKS 1 02-01-2008 4 12 15 32 39 2 02-02-2008 1 3 7 9 30 3 02-03-2008 3 20 21 32 38 4 02-04-2008 2 11 18 27 33 5 02-05-2008 1 12 23 25 40 I need to search columns C through G to determine the date (column B) when a specific number (let's say 12) was chosen. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and lookup | Excel Worksheet Functions | |||
| =IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B | Excel Worksheet Functions | |||
| Help with Lookup(), VLookup | Excel Worksheet Functions | |||
| LOOKUP or VLOOKUP | Excel Worksheet Functions | |||
| Lookup without VLOOKUP? | New Users to Excel | |||
![PJ Murph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
