HLookUp function

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
 
J

JoeU2004

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 -----
 
J

Jacob Skaria

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hlookup problem in knowing what range to use 4
SUM formula after HLOOKUP result true 9
Totalling seperate cells from a HLOOKUP function 8
Hlookup, range_lookup parameter 1
hlookup value within a range 4
Index / Hlookup 1
Hlookup and sum noncontiguous numbers 1
somewhat complex if statement help PLEASE!!!! 1

Top