replace part of formula

[hershel13]

I have formula like this

=SUMPRODUCT(LOOKUP(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),P1:P22,O1:O22))

=SUMPRODUCT(LOOKUP(MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1),P1:P22,O1:O22))

what i went is copy this formula  to many lines and change the B2 by incremental like b3,b4,b5 but leave  this part P1:P22,O1:O22 the same for all records  

can anyone help ?

[#2 · Accepted solution]

@hershel13  The use of the symbol "$" before a column letter or row number will "lock" it (make it absolute reference)  without that "$" it is a relative reference.  Try this:

=SUMPRODUCT(LOOKUP(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),$P$1:$P$22,$O$1:$O$22))