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. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup or...?
Hey, please help an norwegian with a excel-problem..
I have a table where I want to bring back a value from another table (f.ex weeknr). I have the value (f.ex week 23), but the value are more than one time in the other table. I therefore also want to bring along another value (f.ex a name who worked that week) as a criteria.. Possible?? |
#2
|
|||
|
|||
Lookup or...?
As an example, using English function names
=INDEX(Sheet2!C2:C20,MATCH(1,(name=Sheet2!A2:A20)* (weeknum=Sheet2!B2:B20),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. and adjust the ranges to suit -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lene" wrote in message ... Hey, please help an norwegian with a excel-problem.. I have a table where I want to bring back a value from another table (f.ex weeknr). I have the value (f.ex week 23), but the value are more than one time in the other table. I therefore also want to bring along another value (f.ex a name who worked that week) as a criteria.. Possible?? |
#3
|
|||
|
|||
Lookup or...?
okey.. I got a little longer now..
The sign , seems to be ; in my language, even if I have the english versjon. Do you think it's anaother sign for * too..? Bob Phillips skrev: As an example, using English function names =INDEX(Sheet2!C2:C20,MATCH(1,(name=Sheet2!A2:A20)* (weeknum=Sheet2!B2:B20),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. and adjust the ranges to suit -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lene" wrote in message ... Hey, please help an norwegian with a excel-problem.. I have a table where I want to bring back a value from another table (f.ex weeknr). I have the value (f.ex week 23), but the value are more than one time in the other table. I therefore also want to bring along another value (f.ex a name who worked that week) as a criteria.. Possible?? |
#4
|
|||
|
|||
Lookup or...?
I wouldn't have thought so. Semi-colons ; or commas , are list separators
and are set in you Language and Regional Options settings. * is an Excel operator. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lene" wrote in message ... okey.. I got a little longer now.. The sign , seems to be ; in my language, even if I have the english versjon. Do you think it's anaother sign for * too..? Bob Phillips skrev: As an example, using English function names =INDEX(Sheet2!C2:C20,MATCH(1,(name=Sheet2!A2:A20)* (weeknum=Sheet2!B2:B20),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. and adjust the ranges to suit -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lene" wrote in message ... Hey, please help an norwegian with a excel-problem.. I have a table where I want to bring back a value from another table (f.ex weeknr). I have the value (f.ex week 23), but the value are more than one time in the other table. I therefore also want to bring along another value (f.ex a name who worked that week) as a criteria.. Possible?? |
Thread Tools | |
Display Modes | |
|
|