C
certain_death
Hi there everyone,
Can anyone help me with a formula...I don't know whether its possible.
Currently I am using a SUMIF against a pivot table to find a currenc
amount against code 784 eg =SUMIF('CB-12'!C:C,"784",'CB-12'!D
) Colum
C is the where the codes are stored and Column D is where the values ar
stored. It also stores a document number in Column B, and I would lik
to lookup that document number for all other codes apart from 784 an
return that currency value based on the original lookup of 784.
(I.e Steps :
1) Lookup up all documents with code 784 and return value.
2) For those documents only, return values that do not have code 784.
I may have explained this a bit ski-wiffy, I know this can be done wit
multiple formulas but wondered if anyone knew of a way to get this int
one formula.
Thanks for lookin,
Regards
Mark
:
Can anyone help me with a formula...I don't know whether its possible.
Currently I am using a SUMIF against a pivot table to find a currenc
amount against code 784 eg =SUMIF('CB-12'!C:C,"784",'CB-12'!D
) ColumC is the where the codes are stored and Column D is where the values ar
stored. It also stores a document number in Column B, and I would lik
to lookup that document number for all other codes apart from 784 an
return that currency value based on the original lookup of 784.
(I.e Steps :
1) Lookup up all documents with code 784 and return value.
2) For those documents only, return values that do not have code 784.
I may have explained this a bit ski-wiffy, I know this can be done wit
multiple formulas but wondered if anyone knew of a way to get this int
one formula.
Thanks for lookin,
Regards
Mark
: