Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset / Match / MAtch
Good afternoon...
The following function =+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5 Is not supported by the reporting application i am using (Excelsius)... Anyone know how I could transform this function to obtain the same result and avoid the use of OFFSET? Thanks so much |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset / Match / MAtch
Hi Michael
Try =INDEX($B$10:$V$161,B7,C2)*$C$5 -- Regards Roger Govier "Michel Khennafi" wrote in message ... Good afternoon... The following function =+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5 Is not supported by the reporting application i am using (Excelsius)... Anyone know how I could transform this function to obtain the same result and avoid the use of OFFSET? Thanks so much |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset / Match / MAtch
=INDEX($B$10:$V$161,MATCH(B7,$B$10:$B$161,0),MATCH (C2,$B$10:$V$10,0))*$C$5
have no idea if it will work in Excelsius though also, there is no need to start a formula with a plus sign in Excel -- Regards, Peo Sjoblom "Michel Khennafi" wrote in message ... Good afternoon... The following function =+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5 Is not supported by the reporting application i am using (Excelsius)... Anyone know how I could transform this function to obtain the same result and avoid the use of OFFSET? Thanks so much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If And Match With a MAX and Offset | Excel Discussion (Misc queries) | |||
Match Offset by more than one value | Excel Worksheet Functions | |||
Match Value and then offset | Excel Worksheet Functions | |||
MATCH and OFFSET | Excel Worksheet Functions | |||
Using MAX with OFFSET and MATCH | Excel Worksheet Functions |