Excel Problem (1 Viewer)

[AlaminK]

Hello,
I have attached an example of my problem that have been struggling for several days to solve.
Just need to find the respective <Price> from another Table2, matching the YarnID AND the closest <Created Date>
Please help.

 

[CJ_London]

Just googled your question - found this as first returned link

Find the Closest Match in Excel (Nearest Value) - Easy Formula

Learn how to find the closest match in Excel using the INDEX-MATCH or XLOOKUP formulas (with examples for finding the nearest value).

spreadsheetplanet.com

 

[ebs17]

Query solution in Access

SELECT
   T1.CreatedDate,
   T1.Yarn1,
   (
      SELECT TOP 1
         T2.Price
      FROM
         Table2 AS T2
      WHERE
         T2.Yarn = T1.Yarn1
            AND
         T2.CreatedDate <= T1.CreatedDate
      ORDER BY
         T2.CreatedDate DESC
   ) AS Price
FROM
   Table1 AS T1

 

[arnelgp]

using ADODB.Recordset.