Assume your source table as posted in A1:F4
Assume the 2 inputs are in H2:I2, eg: 10, 80s
Then in J1: =INDEX(C2:F4,MATCH(H2,A2:A4,0),MATCH(I2,C1:F1,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"atikah" wrote:
DN SCH WEIGHT(kg/m)
10 80s ???


??? to read from this table
dn sch 5s 10s 40s 80s
6 0.00 0.28 0.36 0.48
8 0.00 0.51 0.64 0.80
10 0.00 0.64 0.86 1.12

how to command the ??? read as 1.12?