Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup query
I am a bit rusy with LOOKUP and much better on IF statements. My problem is
I have 14 conditions to consider and IF will only go up to 7. Here's what I want to say: 1c is equal to 7 points 1b " 9 " 1a 11 2c 13 2b 15 2a 17 3c 19 3b 21 3a 23 4c 25 4b 27 4a 29 5c 31 5b 33 Any one of the above number letter score could go in the required field so they all have to be in the formula. If I type say 4b into a box I want the number 25 to appear in the answer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible lookup query - XL2003 | Excel Discussion (Misc queries) | |||
Lookup query in excel | Excel Worksheet Functions | |||
stock quote lookup query for Excel 2000 | Excel Worksheet Functions | |||
Help please! Lookup/Index query. | Excel Discussion (Misc queries) | |||
Matrix Query Part II - lookup value | Excel Worksheet Functions |