Vlookup issue : When column are added to

Hi,

I have successfully applied a Vlookup from reference sheet to my parent sheet. However, when a new column is added within that range in reference sheet then input value also changes and it doesn't remain static.

Is there a way to apply same logic like Excel with $ sign to make the Reference value/Reference column static.

Tags:

Best Answer

Answers