How to multiply two columns and get result in third range for a function

Hi everyone,
I've searched far and wide but I'm not really getting what I'm doing wrong. This is a really simple procedure that I need to understand to make more complicated functions. I am not making a sub or using a designated column on a worksheet, this needs to be a function so it has to be range/variable based. I'm not an expert on VBA so I apologize for any mishandlings of correct terms, I'll try my best.

What I want:
Input:
Column A: [3,4,8]
Column B: [7,3,11]
Output:
Column C: [21,12,88]

This is what I've been trying to use, and modifying to no avail:

Function ExpectedReturn(ColumnA As Range, Column B As Range)
Dim RangeColumnA As Variant
RangeColumnA  = ColumnA 
Dim RangeColumnB As Variant
RangeColumnB = ColumnB
For Each RangeColumnA In RangeColumnB
RangeColumnA = RangeColumnA.Value * RangeColumnB.Value
Next RangeColumnA
End Function

I need to have the result display in a range like the index function does and the range itself needs to be able to be variable (not limited to a place on the worksheet, like the range that is chosen for the function can be 1-2 variables or 150 +. Of course for this to work the ranges A and B need to be equally long.

This would really further my understanding if I could work with ranges like this, thank you very much for reading