Is this an index match formula?

[PaddyP]

Have not done one of these in a couple years.

Need a formula in F1 that will return the value in Column B that matches E1 * the value in column C that matches E2.

Thanks for the help.

[Bo_Ry]

Please try

=VLOOKUP(E1,$A$1:$C$4,2,0)*VLOOKUP(E2,$A$1:$C$4,3,0)

[etaf]

yes,
=(INDEX(B:B,MATCH(E1,A:A,0)))*(INDEX(C:C,MATCH(E2,A:A,0)))

[PaddyP]

Thank you both for the quick reply. I should have thought to use the Vlookup*Vlookup. Ill use the Index formula instead as I need more practise with this.

Thanks and be well.

[etaf]

you are welcome