View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
0-0 Wai Wai ^-^
 
Posts: n/a
Default Advanced Lookup (lookup for 2 values)


Hi.
I have a worksheet which contains Risk Level & Profit Level.
Row A contains risk number. Column A contains Profit number.
Different risk number & profit number will generate a risk-profit ratio.
For the look of the worksheet, see attachment.

Q:
How can I lookup for 2 values (risk number & profit number) and returns the
answer (risk-profit ratio)?
The command will be something like:
If risk number is XX & profit number is YY, the risk-profit ratio is ZZ.

Thanks for your help.



--
Additional information:
- I'm using Office XP
- I'm using Windows XP

本人的能力非常有**. 如有不當之處, 望識者不吝賜正!!
After all, the above are merely my little opinion/idea.
Since my ability is limited, I could be wrong.




Attached Images