VLOOKUP array formula not working

[kborgers]

Hi all,
I have just started to put together a new workbook based upon a similar one that I did last year. I have copied a formula from the previous workbook (adjusted for the new one), checked, checked and checked again but I cannot get it to work! It follows the EXACT pattern of the previous workbook but returns #N/A as a result. I have attached the new workbook and I hope that what I'm trying to achieve is apparent. I need to return the Item Number in 'Formats!', column B, from the 'Orders!' sheet. The products have unique item numbers but some commonality in format (102, 114, 120 or 162). Orders will be entered and therefore listed chronologically in the Orders sheets but I need ot separate them by Format in the Format sheet. Any bright ideas??

[Haseeb Avarakkan]

You have #N/A error in Orders sheet. Change the formula in Orders!A4 to;

=IFERROR(VLOOKUP(D4,Details!$A$3:$D$128,4),"") COPY DOWN.

Then in Formats!B8, copy down.

=IFERROR(INDEX(Orders!D:D,SMALL(IF(Orders!A$4:A$25=B$6,ROW(Orders!A$4:A$25)),ROWS(B$8:B8))),"")

Array Entered.

[kborgers]

Haseeb - I could say that it's been a long week (which it has), that I'm getting older (which I am) and that sometimes the most simple of solutions are missed (which it was) but what I will say is 'thanks very much. You're a star!'.