I am after some help trying to get a formula to work and being a Newbie to excel im coming across some problems along the way.

i have been looking at the posts to try and find a solution but unable to find anything that relates to what im trying to do.

I am trying to use data from Sheet 1 and record the results on sheet 2.

I have managed to do single lines on Sheet 1 and the formula seems to work, however when I try to look at the whole sheet I get a value error.

This is the data im using:

A B C D E F G

1 A001 Drop N/A Cream L783 1L N/A

2 A001 Lift Cream R557 1L N/A

3 B002 Lift Dream Chips R556 1L N/A

4 B002 Lift N/A Cream L666 2L N/A

5 A001 Drop split Cream L786 2L N/A

To be added to daily so data sheet will get longer

This is the formula im using to work on a single line on a single sheet which is working:

=IF(AND(K12="A001",L12="Drop",N12="Cream",P12="2L",O12=K25),"Yes","NO") This gives me YES.

This is the formula I tried to use all of the data and get a "value" error:

=IF(AND(K8:K12="A001:",L8:L12="Drop",N8:N12="Cream",P8:P12="1L",O8:O12=K22),"Yes","NO") This gives me a VALUE error.

This is wht I need to show on sheet 2 to encorporate all of the relevant data from sheet 1

Cream

A B C

1 1L 2L

2 L783 #VALUE!

3 L784

4 L785

5 L786 Yes

6 L787

I hope I have given enough explaination for what I am trying to do and appreciate any help anyone can give.

Sorry for the data supplied but I cant seem to paste a copy of my spreadsheet and I have spread It out but it dosnt seem to align.

Thanks in advance