i think after you have already done the vlookup you copy paste same as values. or just keep the formula on only the first row and paste the others as values. sometimes i do it like that because me also we are not allowed to keep file with larger size.
Bookmarks