VBA Using Arrays for lookup

[dodo1051]

Hi guys,

so i have a set of data with 600k rows, and i was using index-match to lookup value but its really slow, so i'm starting to look into vba,
but, i still dont quite understand the concept of two dimensional arrays, am i able to reference a column with a header name (like python)?
and is the data structured per row?

for example, how do i fill value for tbl_result.ListColumns("Price").Range
providing data from tbl_ref?

	tbl_result
	A	B
1	Fruits	Price
2	Apple	?
3	Pinapple	?
4	Grapes	?
5	Pear	?
6	Orange	?

<tbody>
</tbody>

	tbl_ref
	A	B	C
1	Fruits	Loc	Price
2	Apple	CN	500
3	Pinapple	INDO	200
4	Grapes	SING	320
5	Pear	TW	110
6	Orange	TH	550

<tbody>
</tbody>

 

[offthelip]

Have a look at this thread that shows you how to do a Vlookup using variant arrays:
https://www.mrexcel.com/forum/excel-questions/1043185-vlookup-vba-alternative.html