How to use array declared in VBA in spreadsheet

I have posted a similar thread at https://www.mrexcel.com/forum/excel-...provement.html

I am declaring a table as an array.

Dim myarray As Variant
myarray = Sheet4.ListObjects("Data").DataBodyRange.Value

How can I use the myarray array in my excel spreadsheet? I want to VLOOKUP the array.