Lookup - so why has it stopped working.

[Robert Gillard]

I have taken over a worksheet that contains a lookup on another sheet.

It checks the date on sheet 1 and looksup the desired value in column 2 on
sheet2. Each month sheet2 is updated and then I "drag down" a fresh row for
the new month on sheet 1 and it auto fills via the lookup... but not this
month! (I believe the lookup is "lookup(b57,sheet_2:2) this is from memory
so the punctuation may not be quite right.

Sheet2 is highlighted with the lookup area, but it stops one row short for
this month, ok so I thought just drag it down to included this months
entries. When you do that all of the values in this months row change (there
are no formulas in the cells)

It would appear that the lookup area has been fixed at a maximum at some
time in the past, but I do not know how to find out where!! any suggestions
please

Bob

 

[Don Guillett]

You really need to look in HELP index for LOOKUP or VLOOKUP. You probably
have the lookup table with absolute references (as it should be) that you
need to adjust $A$1:$x$400 (the $ mean absolute references)