Hi Gurus,

I have a query about using Array Variables in excel VBA. I have a set of lookup tables and a main data table. The data table will be downloaded everyday. I need to replace the ID's in this using the Lookup tables.

e.g.
Lookup Table 1
001 - Red
002 - Blue
003 - Green
004 - Violet
005 - White

Lookup Table 2
323 - Operator 1
324 - Operator 2
325 - Operator 3
326 - Operator 4
327 - Operator 5
328 - Operator 6

Main Data Table
Operator Name Color
325 005
326 004
327 003
328 001
322 002

I have a huge amount of data in the main table. So I can't use a lookup formula for automation. Rather I would like to use VBA to create array variables, copy the lookup data into the array and replace the ID's in the main table.

Only that I am unable to achieve this. I am very basic in executing code related to Arrays.

Any help is highly appreciated. Thank you,

cheers,
Ravi.