Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I need to enter a formula that will look up information in a table and
give me a text answer, e.g. here is the table low likelihood Medium Likelihood high likelyhood low inpact Low Risk Low Risk Medium Risk medium impact Low Risk Medium Risk High Risk high impact Medium Risk High Risk High Risk so if a had 2 cells that listed the impact and likelyhood, e.g. low impact and high likelyhood, the answer would be Medium risk Any idea of which formula could help me do this? Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |