VBA Code Needed to Replace Lookup Formula

Hello Gurus of Excel,

I'm currently in a bind where I'm looking to replace a lookup formula with a vba code (hopefully). I was looking to find a method to convert this formula ('=LOOKUP(2,1/(C7=Data!$A$2:$A$200)/(D7=Data!$B$2:$B$200),Data!$C$2:$C$200)) into VBA code. The goal would be to be able to have to lookup table work with the VBA code and then press a button to get the results from the data being that I will have thousands of rows of data using a VBA code would help quicken the process. All my reference information is on the "Data" tab (this will be updated from time to time) and the sample tab is where the lookup and return results will happen. I provided a sample within this post.

Thank you for any help that be provided...

Hi CK76,

Thanks for taking the time to look at this. Quick question with the VBA you provided will this continually update if I add more data to the "Data" tab?

You just have to run the code again. It will grab range dynamically.

Or tie it to Worksheet_Change Event. Really would depend on your use case.

Thanks CK76! This code works perfectly. Thank you again for taking the time to help!

You are welcome and thanks for the rep