.... got my rows and colums wrong way round ... sorry!

=INDEX($B$3:$F$8,MATCH("Q",$A$3:$A$8,0),MATCH("c", $B$2:$F$2,0))

"Toppers" wrote:

Ian,
Still INDEX but I misinterpretted your table (my fault!).

Assuming your table is in range A1:F8 use the following:

=INDEX($B$3:$F$8,MATCH("c",$B$2:$F$2,0),MATCH("N", $A$3:$A$8,0))

$B$3:$F$8 is (array) of the costs
$B$2:$F$2 are the locations
$A$3:$A$8 are the locations

The MATCH functions find the row and column intersetctions to give the
location in array
$B$3:$F$8

As before you can assign "c" and "N" to cells and replace these by cells in
the formula.

HTH

"Ian Murdoch" wrote:


Thanks Toppers, but not sure how it works with say :

LOCATION
EQUIPMENT a b c d e
L 1 3 1 4 9
M 6 1 7 20 2
N 7 8 7 8 4
O 14 1 5 6 7
P 6 2 1 516 56
Q 14 34 54 76 77

so by identifying location say, c and equipment say, n, how do I get it
to throw up 7

Rgds

Ian


--
Ian Murdoch
------------------------------------------------------------------------
Ian Murdoch's Profile: http://www.excelforum.com/member.php...fo&userid=8441
View this thread: http://www.excelforum.com/showthread...hreadid=566581