Question:
Is there a technique to embed Excel functions such as VLOOKUP() in BEX query results, so that the results can also pull lookup values from a workbook table?
Answer:
Hi!
There's a Visual-Basic user exit called after the execution of a query. It can be used for applying VB/Excel functionality to the result area of a query.
Pressing <alt>+<F11> in BEx will take you to the VB window. The "empty" sub routine "SAPBExOnRefresh" already exists.
Kind regards,
Christian