ExcelBanter - Setting a column read figure from table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Setting a column read figure from table (https://www.excelbanter.com/excel-worksheet-functions/213101-setting-column-read-figure-table.html)

atikah

Setting a column read figure from table

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?

Max

Setting a column read figure from table

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?

Max

Setting a column read figure from table

Typo
Then in J1:

should be
Then in J2:
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

All times are GMT +1. The time now is 03:43 PM.