Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and match questions
I have data as follows:
column column column C A b(date) c(result) 1 2006/5/1 c 1 2006/5/2 c 1 2006/5/3 a 2 2006/5/1 b 2 2006/5/2 a 2 2006/5/3 c What formula should I input that would come out result with 'b' in cell f1 when I type in d1=2, e1=2006/5/1? Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and match questions
=INDEX(C2:C20,MATCH(1,(A2:A20=D1)*(B2:B20=E1),0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Anna" wrote in message ... I have data as follows: column column column C A b(date) c(result) 1 2006/5/1 c 1 2006/5/2 c 1 2006/5/3 a 2 2006/5/1 b 2 2006/5/2 a 2 2006/5/3 c What formula should I input that would come out result with 'b' in cell f1 when I type in d1=2, e1=2006/5/1? Thank you for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and match questions
=INDEX(C2:C7,MATCH(D1&E1,A2:A7&B2:B7,0))
ctrl+shift+enter (not just enter) "Anna" wrote: I have data as follows: column column column C A b(date) c(result) 1 2006/5/1 c 1 2006/5/2 c 1 2006/5/3 a 2 2006/5/1 b 2 2006/5/2 a 2 2006/5/3 c What formula should I input that would come out result with 'b' in cell f1 when I type in d1=2, e1=2006/5/1? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup returns blank if no match | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Match Index Lookup | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions |