Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look UP formula for 2 and 3 conditions
Hello,
Could you please look in to the attached file and advise formula for the two cases shown ? I will need a formula to look up data matching multiple condtions. Regards, Dumbo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look UP formula for 2 and 3 conditions
Hi,
Am Tue, 2 Apr 2013 09:32:54 +0000 schrieb Excel Dumbo: Could you please look in to the attached file and advise formula for the two cases shown ? I will need a formula to look up data matching multiple condtions. for the first lookup try in B5: =INDEX('LookUP data'!C$5:C$8,MATCH($B$3&$A5,'LookUP data'!$A$5:$A$8&'LookUP data'!$B$5:$B$8,0)) and enter the array formula with CTRL+Shift+Enter and copy down and to the right. for the second lookup try in C13: =INDEX('LookUP data'!$A$14:$M$17,MATCH($A13,'LookUP data'!$A$14:$A$17,0),MATCH(C$12,LEFT('LookUP data'!$A$14:$M$14,3),0)) and enter the array formula with CTRL+Shift+Enter and copy down and to the right Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Thanks a lot Claus. It worked. Thanks heaps
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula with 2 conditions | Excel Discussion (Misc queries) | |||
IF formula for 3 possible conditions | Excel Discussion (Misc queries) | |||
Formula With Several Conditions | Excel Worksheet Functions | |||
If formula with 12 conditions | Excel Discussion (Misc queries) | |||
Help for a formula using two conditions | Excel Worksheet Functions |