HLookUp function

  • Thread starter Thread starter Jbig
  • Start date Start date
J

Jbig

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
 
Jbig said:
I need to multiply my value in C4 to the risk level range.
Click to expand...

Not sure I understand, but I think you want:

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


----- original message -----
 
=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
 
Back
Top