Thread: Vlookup problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mariomaf
 
Posts: n/a
Default 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