| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting everyone to read ony | Excel Discussion (Misc queries) | |||
| Setting column width in a table | Excel Discussion (Misc queries) | |||
| Setting read only permissions | Excel Discussion (Misc queries) | |||
| How do i remove READ ONLY setting on a file? | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
