"Sheeloo" wrote:

How are you copying the formula to other cells?
=VLOOKUP(B3-0.1,A7:AB20,2,FALSE)
will change to
=VLOOKUP(B4-0.1,A8:AB21,2,FALSE)
when copied down...

Use
=VLOOKUP(B3-0.1,$A$7:$AB$20,2,FALSE)
Also since you are picking up values from column B you can also use
=VLOOKUP(B3-0.1,$A$7:$B$20,2,FALSE)


"Matin D HJE" wrote:

Thank you for the reply but I am not copying the cells down. A single look
uo cell is being used as part of a scientific 'calculator' for extracting
correction data from the table part of which I included in the original
enquiry. This look up cell is then accessed by a further calculation which
exists in another worksheet within the workbook.