Hi,

When i am trying to copy a Vlookup formula from one cell to others, its not
getting copied the way it should be. The source is getting changed for every
next cell. Although i selected "COPY CELLS" or fill the series, its the same
issue.

EX:
=VLOOKUP(D17,'Defect Table'!A1:B24,2,FALSE)

=VLOOKUP(D20,'Defect Table'!A2:B25,2,FALSE)

=VLOOKUP(D21,'Defect Table'!A3:B26,2,FALSE)

Regards,
Sri Harsha.