VLOOKUP using VBA to auto fetch data

Dear All,

I am having one Tracking sheet for recording data. I want to fetch some values/ data from other worksheet for some columns.

Identifying ‘Request ID’ particular cells should auto fetch data from other worksheets.

Request ID is one unique number. Therefore, it will lookup the Request ID in another worksheet & gets related cell data it in master database.

I have tried VLOOKUP for this and this is giving correct outcome.

However due to ample number (7000) of rows, while saving it goes to "Not responding" mode.

So can you please give some VBA code so that I can fetch the values for specific columns/ cells.


e.g.
=VLOOKUP(A3,Publisher!$A$3:$M$1048576,11,0)

A3 = Request ID
Publisher!$A$3:$M$1048576 = table_array from Publisher TAB


Best Regards,
Rahul