Look UP formula by referencing certain values of lookup cell
 

Hello Dear Friends,

Could you please refer the attached file and help me build a lookup formula that matches certain values of the lookup cell, and also a formula to extract certain values from a destination cell.

Any help will be appreciated.

Regards,
Dumbo

Hi Friends

I managed to get the above file solved. But I came across another problem.I had another question regarding lookup by referencing multiple columns. Please refer attached. Can you please advise a solution ? Thanks

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