Look UP formula by referencing certain values of lookup cell
Hi,
Am Thu, 13 Nov 2014 04:02:05 +0000 schrieb Excel Dumbo:
+-------------------------------------------------------------------+
|Filename: Lookup referencing multiple columns.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=994|
+-------------------------------------------------------------------+
in B2:
=IFERROR(INDEX($N$3:$N$16,MATCH(A2&C2,$K$3:$K$16&$ L$3:$L$16,0)),0)
and insert the array formula with CRTL+Shift+Enter and copy down
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|