| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forumla that Looks up a range of output from one cell
I have been struggling with getting a formula to look at the input of one
cell, decide where it falls within a range, and then determine where to go lookup the correct output. Here is the formula I am using: =IF(I10<90%,LOOKUP(C8,C8),IF(I1090.01%<105%,LOOKU P(E8,E8),IF(I10105.01%<115%,LOOKUP(G8,G8),IF(I10 115%,LOOKUPI8,I8)))) This will give me either C8 or I8. The other formula I used was: =IF(I10<90%,LOOKUP(C8,C8),IF(I1090.01%,LOOKUP(E8, E8),IF(I10105.01%,LOOKUP(G8,G8),IF(I10115%,LOOKU PI8,I8)))) This will give me C8 or E8. So am I stuck to just this TRUE/FALSE or is there a way to have the additional conditions met? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to enter output range for Descriptive statistice | Charts and Charting in Excel | |||
| Combo Box to populate variable output range | Excel Discussion (Misc queries) | |||
| Print output does not contain entire range | Excel Discussion (Misc queries) | |||
| Printing same spreadsheet range getting different output | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
Threaded Mode
