Hi,
I am using VLOOKUP function in sql query. I have two sheets. I am trying to use VLOOKUP function programatically. When I click the button on excel sheet, It loads the data in two sheets. But VLOOKUP is in one of the SHEET'S sql query. 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?
Thank you very much
Bookmarks