I have a worksheet with over 30K records.

I am using a Vlookup in Sheet A , for 4 columns and then dragging it down.
(totallly 120K apprx)

It looks something like this in the Macro :
"=VLOOKUP(C[-2],acc!C[-5]:C[7],3,FALSE)"

however, It slows the application a lot.

Is there an alternative?