如何使用INDEX和MATCH功能与VBA，Oracle和Excel进行绑定？

I am trying to create a program using VBA that queries my oracle database data (in this case pipelines) against a spreadsheet and produces an output of the tie-out on the same workbook (but on another sheet). I would like to use the INDEX and MATCH functions on the tie-out page but have trouble figuring it out. Here is what I have so far (graphical representation below) and here are my questions:I am trying to create a program using VBA that