Hi,
I am using VLOOKUP function in sql query. I have two sheets. I am trying to use VLOOKUP function programatically. But when I run It doesn't display the proper VLOOKUP value. It displays only the formula. I am using VLOOKUP like this.

SELECT roi.ganumber, roi.cont_eff_date,
'=VLOOKUP(A2,''Internal Team Data''!A:D,4,FALSE)'
FROM rpsc_opp_install roi,

It displays only the formula as it is. How can I get the data? Is there any way I could get the matching data. Once the sheets were loaded with the data, Is there any way I could write a macro that runs all the cells automatically which has this VLOOKUP function.

Thank you very much