Look UP formula for 2 and 3 conditions
1 Attachment(s)
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 |
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 |
Thanks a lot Claus. It worked. Thanks heaps
|
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com