Vlookup issue
 

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.

Vlookup issue
 

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)

"Sri Harsha" wrote:

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.

Vlookup issue
 

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Sri Harsha" wrote:

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.