| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
I have a series of data in a two row and need to make a conditional lookup.
The problem is, that a conditional formula is restricted to 7 arguments. The problem: I have two rows. In the upper row is a target value for each month and in the lower the realized value is entered. In a column i need: 1. the latest entered realized value 2. the target value corresponding to the latest entered realized value. I hope you can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
