Combining AND with HAS and WEEKNUMBER

Joseph Adams

Hello Again,

My goal is to have a formula that will do the following:

If the Lot ID@row is found on the {Lot ID} column on an Archive sheet

AND

The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@row

THEN give me a value. If not then 0.

=IF(AND(HAS({Lot ID- Archive}, [Lot ID]@row)), WEEKNUMBER({Move Date- Archive}), [Week #]@row), some value, 0))

My formula above isnt working. I always get mixed up with AND formulas. I also think I can use the @cell function but again I am not good with that one

Any help would be appreciated

Paul Newcome

Try this instead...

=IF(COUNTIFS({Lot ID- Archive}, @cell = [Lot ID]@row, {Move Date- Archive}, IFERROR(WEEKNUMBER(@cell), 0) = [Week #]@row) > 0, "some value", 0)