| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem
This is my code: =IF(ISERROR(SMALL(IF('Uitgevoerde en geplste. orders'!$K$5:$K$13="b";ROW($K5:$K13);"");ROW($K5:$ K13)));"";INDEX('Uitgevoerde en geplste. orders'!$L$5:$L$13;SMALL(IF('Uitgevoerde en geplste. orders'!$K$5:$K$13 ="b";ROW($K5:$K13);"");ROW($K5:$K13)))) It leaves my fields empty... but gives no error -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=497836 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Threaded Mode
