Is there a way to put the vlookup formula without looping involve?

Hi all expert out there,it is me again, actually I am having a hard time on how can my macro process will be a little bit faster regarding of putting up a vlookup formula without looping involve on vba code. Like I have 6000 data and I have to use vlookup to populate a column, but then when I am using a looping formula( While,do while,for) time of process takes too long and it effect that the user can't use other excel file to work on a other report. So, for example that I have a header on row 1 and on row 2 column B has already a vlookup formula, data will be on Column A,I will copy first the formula on b2, now how can I select the last value on Column A select empty cell on Column B and select it up until row 2 to paste the code? I think looping can take a lot of time to process for putting up a vlookup formula. Thanks. sorry if I you have trouble understand my problem

Sounds like you need this;

Please Login or Register  to view this content.

Replace this --> "=VLOOKUP(,,,,,,,,,,,,,)" with your lookup formula. Insert your formula BETWEEN the quote marks.

Record your formula with the macro recorder, then copy the R1C1 style formula into the area I described.

Give my sincere apologies to that poor excel user who will no longer be able to take a coffee break while the old looping code runs

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"