Solved: product begins with XY

[danovkos]

Hi all,
pls. i have one question.

How can i do following?

I have sheet „source“. In this sheet i have acounts in column A, subacounts in col. B and products in col. C.
One acc. (A) can have more then one subacc. (B).

I have list of acc. in other sheet „sum“ and i want to each acc assign info, if is there in „source“ in column C for whole acc any product, which names begins with „HU“.

Please how can i do that?

This is table about 6000 rows.

[lucas]

You will have to provide more information I think.

A sample workbook with some notes would be really helpful to anyone trying to assist you.

[danovkos]

Here is a sample.

I think there can be a formula in sheet sum in column B2:B17 wich result will be as is it in sample.

Thank you for all your help.

[Bob Phillips]

Try

=IF(SUMPRODUCT(--(source!$A$2:$A$23=A2),--(LEFT(source!$C$2:$C$23,2)="hu")),"YES","no")

[danovkos]

yes,
this works perfect
thx a lot

[danovkos]

SORRY, only one short question.
It works only for 4000 rows?
becasue if i use 4000 rows as source it works but 5000 not

[Bob Phillips]

Just change the range reference to 5000 surely?

[danovkos]

Just change the range reference to 5000 surely?

yes i changed it to 5000 but it return
#REF!
It is strange, because i change reference and till 4000 it works perfect , but after 4000 it does not
Can by the problem, that my table is devided with blank rows ?

[danovkos]

SORRRY, I AM STUPID,
now i figured out, that in my column with product was one value ref(error) and this made problem.
Now it is ok.
Sorry one more time and thx.