Moving a formula's references in an easier way

[sahmed95]

Good morning,

I am using an IF formula to check if a minimum value is met, if not the target amount of 2500 will be taken.

I have linked the week's figure to the minimum week figure for that month (at the moment they all say 2500, but this will change)

The problem is that at the moment the only way I can think of amending this is manually or with a find and replace, is there a way I can simply move the references a month at a time?

Thanks

[Pete_UK]

There is not much point in attaching a picture of a workbook. For one thing, I can't read any of the details, and for another I could not edit it if I could read it. You should attach a sample Excel workbook, as you clearly have one - just follow the instructions in the yellow banner at the top of the screen.

Pete

[sahmed95]

Ok thanks, added in now.

[Haseeb Avarakkan]

Hello,

Try this in G3, then copy down.

=MAX(F3,HLOOKUP(A3,K$2:V$3,2,1))

[sahmed95]

Hi Haseeb,

Thanks, I have amended the formula in, but it seems it takes the first week's value only, (from K3); I wanted to drag and extend from K2:V7, but am not that familiar with this formula.

I have reattached.

[Haseeb Avarakkan]

...then

=MAX(F3,LOOKUP(A3,K$2:V$2,K3:V3))

[sahmed95]

Thanks, I'll amend and check