View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default HLookUp function

"Jbig" wrote:
I need to multiply my value in C4 to the risk level range.


Not sure I understand, but I think you want:

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


----- original message -----

"Jbig" wrote in message
...
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