How to Use XLOOKUP In VBA

I have a datasheet that contains many cells that receive data from an SQL query.

The data arrives in 'text' format.

To perform numerical comparison, I convert the data to numeric, after doing so, the value goes to decimal format.

Depending on the result, determines the format I want to apply.

Data Sheet:
COL-A = Unit Number
COL-B = System Name
COL-C = Analysis Name
COL-D = Sample Date/Time
COL-E = Oldest Result
COL-F = Second Oldest Result
COL-G = Most Recent Result

Another sheet retains the formatting information
COL-A = Unit Number
COL-B = System Name
COL-C = Analysis Name
COL-D = Assigned Format

I am trying to use XLOOKUP to reformat the newly converted text-to-value. See the modSupportCode VBA sheet.

Any assistance is truly appreciated.

Thank you. The Lookup_Value returns as empty?

Yes, Windows 10 Enterprise, using 365 Excel.

I'll try again.

I have copied the entire post you provided, IT DOES WORK!

Thank you.