VBA Code for XLOOKUP Using Multiple Criteria That Are Dynamic

Hello,

I need help writing a VBA code for macro that will perform an XLOOKUP formula based on three lookup values from a return array that is a sub-total. Since the return array is a sub-total, I have to perform "Select Visible Cells" to paste the data into a new sheet in order to do my XLOOKUP formula. I would like to know if there's a way to do the XLOOKUP based on the visible cells of the return array, so that I don't have to paste the data into another spreadsheet.

Also, I would like the macro to only run the XLOOKUP formula if the column header contains a specific name that I designate.

The original version of the workbook has thousands of rows, so the lookup value combination will change as we go through each row, making it dynamic. Below are print screens of my data with my formula in Excel, as well as the attached sample workbook.

Many thanks for assisting me with this!