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