Thanks, I getting it but one problem

Here's my formula

=IF(Jan_PL_complete_all_classes!A3:A108=Jan_PL_com plete_all_classes!A3:A139,Jan_PL_complete_all_clas ses!B3,0)

The only thing wks 1 column A "wording" if it matches wks 7 column A
"wording" then value in column B that matches that column

Example

Wks 1

XX 1234
YY 4930
ZZ 393

Wks 7

XX 1234
AA 0
YY 4930
ZZ 393
BB 0

"Max" wrote:

"Ms. D" wrote:
Thanks - too hard to understand - can you make it a simple

Ahh, thought I had read your original posting quite okay. That you had that
kind of underlying complex scenario to handle. What was suggested earlier was
really a simple way to tackle that scenario.

Ok, as for my reading on this ..
if wks 1 column "A" = column "A" in wks 7 then enter amt / else 0

I'll half-assume the "amt" is in col B (I went back to your original posting)

You could enter this in say C2: =IF(A2=Sheet7!A2,B2,0)

And if the above did help you in any way to progress on whatever it is that
you're trying to do, do take a moment to press the "Yes" button below ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---