=C4*HLOOKUP(C4,'Risk Levels'!B2:D5, 2, FALSE)

and a error handled version

=IF(ISERROR(HLOOKUP(C4,'Risk Levels'!B2:D5, 2,
FALSE)),"",C4*HLOOKUP(C4,'Risk Levels'!B2:D5, 2, FALSE))

If this post helps click Yes
---------------
Jacob Skaria


"Jbig" wrote:

Wondering if anyone can tell me where exactly do I add the asterisk symbol to
multiply within this function.

So far I have:
=HLOOKUP(C4,'Risk Levels'!B2:D5, 2, FALSE)

I need to multiply my value in C4 to the risk level range.


ANY HELP GREATLY APPRECIATED!!! THANKS