Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Crazy Hard Function
Well, as the title says, I've got a hard function, and I'm at a loss, so here
goes what I'm trying to code. This function will be on Sheet20. Where cell "F4" is found in column "M" of Sheet18, I need it to multiply that row's column "C" by the value of Sheet1's "H1"... Let me try and type it another way. If Sheet20.$$ == Sheet18.M$row <--- I'm implying that I need all rows where Sheet18's column "M" has the same value as a value on Sheet20. Sheet18.C$row * Sheet1.H1 Sheet18.D$row * Sheet1.H2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Crazy If | Excel Worksheet Functions | |||
Going CRAZY with INDEX and Match Function | Excel Worksheet Functions | |||
Loop gone crazy | Excel Discussion (Misc queries) | |||
I'm going crazy here | Excel Discussion (Misc queries) | |||
This is crazy!!! | Excel Discussion (Misc queries) |