Hi!

Ok, I have tried your formula:
It does not work as good as the one I had

It works just fine on my end!

Let me fix this for you and you'll see.

Where should I send the file when I'm done?

Biff

"sonar" wrote in
message ...

Hi Biff

Thanks for the help

It is much appreciated. You can try and clean up the file if you
wish.

The reason why I have seperated the 8digits from the 13digits, is
because they do work differently somehow.

the 8 digits you will find to work fine in Number format, it brings up
the descriptions, the 13 digits works fine in Text format again, as
that brings up the descriptions, it does not want to work when put in
number format. - unless of course, its because my stock items have " '
" in front of the 13 digits, thinking about it now.

Maybe your right, it can still work. I myself will try that.

Ok, I have tried your formula:
=IF(ROWS($1:1)<=COUNT('13DBC'!D$10:D$60),INDEX('13 DBC'!A$10:A$60,
SMALL(IF('13DBC'!D$10:D$60<"",(ROW('13DBC'!A$10:A $60)-ROW(A$10))+1),ROW(1:1))),"")

It does not work as good as the one I had, it gives me
6001009010681 WW - CHOCOLATE BROWNIE DESSERT
6001009012692 WW - TIRAMISU 90G

Instead of
6001009011985 WW - SPIN/FETA ROULADE 500G
2906818000004 WW BUTTERNUT WHOLE

Still does not explain why it ignore my butternut though. but what I
will do however, is take away the " ' " from the 13 digits, convert the
cell formats in 13dbc to number format and see if it accepts, try to
make it like the 8dbc.

Lets see what happens.


regards
Sonar


--
sonar
------------------------------------------------------------------------
sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=470611