Prev: ErrorNext: Faxing from Excel?! From: K on 21 Apr 2010 07:24 Hi all, does any friend know that how can I make below formula work MATCH(A2,\$K\$2:\$M\$30,0) From: Jacob Skaria on 21 Apr 2010 08:35 I am not sure I have understood correectly. Please go through the below example With data as below if you need to retrive the name of the 1st Rank holder from London. D2 = 1 D3 = London In D4 apply the below formula =INDEX(\$B\$2:\$B\$9,MATCH(1,(\$A\$2:\$A\$9=D2)*(\$C\$2:\$C\$9=D3),0)) Please note that this is an array formula. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=}" ColA ColB ColC Rank Name Office 1 Tom R Bath 2 Katy C Bath 3 Nigel G Bath 4 Pete R Bath 1 Tony A London 2 John B London 3 Mary C London 4 Jane D London -- Jacob (MVP - Excel) "K" wrote: > Hi all, does any friend know that how can I make below formula work > MATCH(A2,\$K\$2:\$M\$30,0) > . > From: Dave Peterson on 21 Apr 2010 08:38 Check your other post. K wrote:> > Hi all, does any friend know that how can I make below formula work > MATCH(A2,\$K\$2:\$M\$30,0) -- Dave Peterson  |  Pages: 1 Prev: ErrorNext: Faxing from Excel?!