CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)
19 January 2011Dear friends,
anyone of you can tell me if we are copying vlookup formula from one cell to another after locking the range then it copies the same formula without change.
i want to change the column reference when i copy the formula from one cell to another. can you tell me if thr is any process or macro for the same.
Rajesh
(Service )
(7576 Points)
Replied 19 January 2011
If you are copying the formula completely then the column will automaticcly change but if you are copying the text only (means words defines after the = (equal sign)) the same coulmn value is pasted. Please check the way of copying first.
Sunshine
(Helping All)
(10575 Points)
Replied 19 January 2011
vlookup(criteria,datarange,column no.,true/false)
bas itna hi aata hai...
Juzer Sadikot
(CA - innovative solutions for Imports an)
(1309 Points)
Replied 19 January 2011
Dear Mohan
I understand you have given absolute reference e.g. $A$1.
Delete $ from column reference (for given example it would be deleting $ before "A" and result would be like A$1) and its done.
Regards
Juzer
CAclubindia
