Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easier Match/Offset?
Is there an easier way to do this?
Basicly the Match is looking at a specific field in A12, which needs to be dynamic as I'm pasting this formula down. Once the field matches, it will ofset it based on its Cell Row #-6 rows, then I need it to calculate I21 *the matching row/cell reference. I21 needs to offset based on column. It looks like a mess, but seems to be doing the job. But I'm sure others in the office may get lost, was wondering if there was somethign easier to do. =(OFFSET(I21,0,0)*OFFSET($I$6,MATCH(A12,$H$1:$H$8, 0)-6,0))+(OFFSET(I21,0,1)*OFFSET($I$6,MATCH(A12,$H$1: $H$8,0)-6,0))+(OFFSET(I21,0,2)*OFFSET($I$6,MATCH(A12,$H$1: $H$8,0)-6,0))+(OFFSET(I21,0,3)*OFFSET($I$6,MATCH(A12,$H$1: $H$8,0)-6,0)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lloking for an easier way to count | Excel Worksheet Functions | |||
Is there an easier way? | Excel Discussion (Misc queries) | |||
Procedure to make a dropdown list larger so it's easier to read | Excel Discussion (Misc queries) | |||
Easier Way? | Excel Worksheet Functions | |||
Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) |