Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up problem
Hi
I have a data table with batch durations along the top from 1 to 36 and start times down the side from 1 to 24. At each intersection of batch duration (col) and start time (row) there is a value to be interogated. How do I find the intersection value of a particular duration (col) and start time (row)? Hope this makes sense Thanks Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up problem
On Thu, 1 Jan 2009 05:13:31 -0800 (PST), "
wrote: Hi I have a data table with batch durations along the top from 1 to 36 and start times down the side from 1 to 24. At each intersection of batch duration (col) and start time (row) there is a value to be interogated. How do I find the intersection value of a particular duration (col) and start time (row)? Hope this makes sense Thanks Martin Assuming that your - batch durations are in B1:AK1 - start times are in A2:A25 - "intersection values" are in B2:AK25 If your duration is in cell B26 and your duration in cell B27, try the following formula: =INDEX(B2:AK25,MATCH(B27,A2:A25,0),MATCH(B26,B1:AK 1,0)) Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up problem
Based on your assumed setup, you don't need to use MATCH.
B26 = a duration from 1 to 36 B27 = a time from 1 to 24 =INDEX(B2:AK25,B27,B26) -- Biff Microsoft Excel MVP "Lars-Åke Aspelin" wrote in message ... On Thu, 1 Jan 2009 05:13:31 -0800 (PST), " wrote: Hi I have a data table with batch durations along the top from 1 to 36 and start times down the side from 1 to 24. At each intersection of batch duration (col) and start time (row) there is a value to be interogated. How do I find the intersection value of a particular duration (col) and start time (row)? Hope this makes sense Thanks Martin Assuming that your - batch durations are in B1:AK1 - start times are in A2:A25 - "intersection values" are in B2:AK25 If your duration is in cell B26 and your duration in cell B27, try the following formula: =INDEX(B2:AK25,MATCH(B27,A2:A25,0),MATCH(B26,B1:AK 1,0)) Hope this helps / Lars-Åke |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up problem
Hi,
Assuming the top left corner of your data table is A1 then =OFFSET(A1,D,T) Where D is the batch duration and T in the start time. You can use cell references or just enter the values for D and T. -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: Hi I have a data table with batch durations along the top from 1 to 36 and start times down the side from 1 to 24. At each intersection of batch duration (col) and start time (row) there is a value to be interogated. How do I find the intersection value of a particular duration (col) and start time (row)? Hope this makes sense Thanks Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |