formula to match cell with date

[CRAIG20]

Hi.

Sample attached.

I would like a formula for cell D2 (in yellow). I want to enter the number from column B which matches the date shown in F2. So in the sample it should display 28458.51 as this is the number which matches date 08/01/25.

Many thanks in advance.

 

[6StringJazzer]

Consider updating your profile to show your version of Excel. The answer will vary depending on that.

=XLOOKUP(F2,A:A,B:B)

if your version does not support XLOOKUP then

=VLOOKUP(F2,A:B,2,FALSE)

 

[CRAIG20]

Consider updating your profile to show your version of Excel. The answer will vary depending on that.

=XLOOKUP(F2,A:A,B:B)

if your version does not support XLOOKUP then

=VLOOKUP(F2,A:B,2,FALSE)

Thank you very much!