Is there a way to lock in the cells you are matching without having to use
the name "cust 1" & "loc 3"? Would the formula look like this:
=INDEX($B$2:$D$5,MATCH(a1,$A$2:$A$5,0),MATCH(b3,$B $1:$E$1,0))

The spreadsheet is pretty large w/ locations & customers & I am trying to
get a the number of stores a customer has for each location. Hope that
makes sense. Thanks. The formula does work if I type in each name though.

"Sheeloo" wrote:

Use
=INDEX($B$2:$D$5,MATCH("Cust 1",$A$2:$A$5,0),MATCH("Loc 3",$B$1:$E$1,0))
assuming Row 1 and Col A contain headers and data is in B2:D5

"JRichardson" wrote:

Need help with a lookup formula using row & column heading:
a b c d
Loc 1 Loc 2 Loc 3 Loc 4
1 Cust 1 6 2 18 1
2 Cust 2 8 20 4 6
3 Cust 3 1 1 8 10
4 Cust 4 2 5 5 1

The formula I need would return the value where the row & column meet (ie.,
return the number where Cust 3 & Loc 2 intersect.

Thanks. jen