Returning Value Based on Two Different Ranges
Hi,
Am Mon, 16 Mar 2015 11:13:26 -0700 (PDT) schrieb cardan:
1. I didn't know you could join ranges like that and,
if you have numbers in the columns you must add another sign, because
31&5 is the same string as 3&15.
So you have to change the formula for example to:
=INDEX(C:C,MATCH(31&"*"&5,A1:A100&"*"&B1:B100,0))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|