Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with VLOOKUP | Excel Worksheet Functions | |||
vlookup issue | Excel Discussion (Misc queries) | |||
Another issue with vlookup | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
vlookup issue | Excel Worksheet Functions |