Vlookup issue

[Sri Harsha]

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.

 

[Crystal Lee]

Hi Sri Harsha,

If the source is fixed (ie 'Defect Table'!A1:B24),

Please use "$" to lock -
=VLOOKUP(D17,'Defect Table'!$A$1:$B$24,2,FALSE)
=VLOOKUP(D20,'Defect Table'!$A$1:$B$24,2,FALSE)
=VLOOKUP(D21,'Defect Table'!$A$1:$B$24,2,FALSE)

 

[Khoshravan]

You have to use fixed reference instead of relative.
Try this one:

=VLOOKUP(D17,'Defect Table'!A$1:B$24,2,FALSE)

Dragging this down, won't change row numbers.