# Paging daddylongleggs - lookup question part 2

1. ## Paging daddylongleggs - lookup question part 2

ddll - you helped me with the formula for Red Chips (column N) in the attached spreadsheet, but I needed it to do more and forgot to ask. I need the red chips to be award to each individual only once per month AND only if the individual earned at least 1 white chip during the same month. Can you (or anyone) please help?

2. in N2 it can not happen so 0
in n3 put

=IF(AND(SUMPRODUCT((\$F\$2:F2=F3)*(\$C\$2:C2=C3)*(\$H\$2:H2=H3)*(\$N\$2:N2))=0,SUMPRODUCT((\$F\$2:F3=F3)*(\$C\$2:C3=C3)*(\$H\$2:H3=H3)*(\$I\$2:I3>0))>0),IF(COUNTIF('red chips'!A\$2:A\$13,A3),VLOOKUP(A3,'red chips'!A\$2:H\$13,8,0),0),0)

and then copy down

Does that work?

Regards

dav

3. Thanks Dav... I pasted it in and works up until the last record. Also, the example is just a snippet of the original. The original may have 10 times the number of rows and will encompass every month of the year. I will play with putting your suggestion into the real thing.

4. Interestingly, the forumula does not work in all instances. Most, but not all.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1