If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 ¥»¤Hªº¯à¤O«D±`¦³**. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!! After all, the above are merely my little opinion/idea. Since my ability is limited, I could be wrong. |
#2
|
|||
|
|||
Advanced Lookup (lookup for 2 values)
Take a look at this:
http://www.contextures.com/xlFunctions03.html I think it describes exactly what you are trying to do. -- tj "0-0 Wai Wai ^-^" wrote: 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 ¥»¤Hªº¯Ã*¤O«D±`¦³Â*Â*. ¦p¦³¤£·Ã*¤§³B, ±æÃѪ̤£§[½ç¥¿!! After all, the above are merely my little opinion/idea. Since my ability is limited, I could be wrong |
#3
|
|||
|
|||
Advanced Lookup (lookup for 2 values)
Thanks.
That's what I want! -- Additional information: - I'm using Office XP - I'm using Windows XP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOOKUP VALUES | Bob | General Discussion | 1 | March 21st, 2006 01:40 PM |
Keep values after lookup | MABeatty | General Discussion | 1 | March 13th, 2006 09:06 PM |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
lookup vs combo box | Scubaman | General Discussion | 4 | June 7th, 2005 02:02 AM |
Lookup Values | Mark | New Users | 5 | June 2nd, 2005 05:32 PM |