lesliewheeler
New Member
- Joined
- Dec 1, 2016
- Messages
- 32
- Office Version
- 2013
- Platform
- Windows
Hi,
I have and excel in which I have approximate 20,00,000 rows (cells vertically down) from which I am using the B column cell starting from B2 and going down the column as reference for vlookup, the formula works fine
formula entered in cell C3
=VLOOKUP(B2,$N$2:$Q$38,4,0)
The problem is the sheet has become very heavy with so many formula pasted and is crashing.
Is there any way a formula or vba code can help for solution and make file less heavy.
I want column C starting from C3 to get updated downward as per the formula I have given.
Any help is appreciated.
Thanks
Leslie
I have and excel in which I have approximate 20,00,000 rows (cells vertically down) from which I am using the B column cell starting from B2 and going down the column as reference for vlookup, the formula works fine
formula entered in cell C3
=VLOOKUP(B2,$N$2:$Q$38,4,0)
The problem is the sheet has become very heavy with so many formula pasted and is crashing.
Is there any way a formula or vba code can help for solution and make file less heavy.
I want column C starting from C3 to get updated downward as per the formula I have given.
Any help is appreciated.
Thanks
Leslie