To look up values in an array, you would run a loop. Because the array is in memory, looping will occur quite quickly.
No, Excel formulas do not have direct access to VBA arrays. You could give formulas access via a UDF (user defined function) but once you are working in VBA, my recommendation is to continue working in VBA and output your results from there (that should be more efficient overall).