XLOOKUP with 2 criteria returning #N/A

[StuckInWork]

Afternoon, I'm hoping someone is able to help me determine the cause of the below #N/A error, the formula is as below, looking up both the date (H14) and time (I14) in separate columns on another sheet to return the data under the PB column.

=XLOOKUP(H14&I14,'Volume Tracker'!E:E&'Volume Tracker'!F:F,'Volume Tracker'!G:G)

The only issue I can potentially see is the formatting of the time and data, however it is formatted the same in both sheets.

Any ideas? Thanks in advance.

=XLOOKUP(H14&I14,'Volume Tracker'!E:E&'Volume Tracker'!F:F,'Volume Tracker'!G:G)

 

[etaf]

working for me - on a quick sample

check the dates and times are real - just change to general format - and all should be numbers

so dates will be something like 45327 = 5/2/24
time 09:30 be something like 0.3958

Book3
	C	D	E	F
11
12		2/5/24	45327
13		9:30	0.39583333
14
Volume Tracker

Cell Formulas
Range	Formula
D12	D12	=E12
E13	E13	=D13

Book3
	G	H	I	J	K
12
13
14		1/1/24	9:30	100
15
16
Sheet1

Cell Formulas
Range	Formula
J14	J14	=XLOOKUP(H14&I14,'Volume Tracker'!E:E&'Volume Tracker'!F:F,'Volume Tracker'!G:G)

Book3
	D	E	F	G	H
2
3
4		1/1/24	9:30	100
5		2/1/24	010:30	20000
6
7
Volume Tracker

 

[StuckInWork]

Thanks, I've a quick look and that seems to have resolved it.

 

[etaf]

you are welcome