| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if problem
Try using FALSE in the range_lookup argument of VLOOKUP (see help for
details). That way the order in the lookup column doesn't matter. In article , samonly wrote: I can't use any of the lookup or index type functions because the numbers are not in numerical order. (I tried pasting the lot (transposed) into a new worksheet and it only works for some values and not others). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with nested IF_OR statement | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| €śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
Threaded Mode
