Look up function

Question

Hi there,

The file attachedincludes a sample of data from two separate sources, shown in two tables:

• Table 1 lists completed vehicle checks on a date and time for a vehicle ID #
• Table 2 lists vehicle ID # where a check has not been recorded

Records in Table 2 are not relevant if there is a record for the same vehicle ID AND on the same date; listed in Table 1. Can you help me with a function to answer this question please?

Example below indicates that there is already a record for Vehicle #170 in Table 1, therefore the report for this vehicle in Table 2 is not relevant.

thankyou.

Table 1

19/08/2024 7:09	Redacted	BEN	1.PreTrip	170	19/08/2024 7:34	658486

Table 2

Redacted	Redacted	FALSE	FALSE	Place name	170	18/08/2024 15:30	19/08/2024 2:00

Answer 1

Good morning Andreas,

I think I have got it to work, thankyou so much again.

These functions do save lots of time and effort.

Thankyou

Jillian

Answer 2

T2: =MATCH([@VehicleID],Table1[VEHICLEID],0)

You'll get the row number if the ID is found in the other table, otherwise an error. Therefore:

T2: =IF(ISERROR(MATCH([@VehicleID],Table1[VEHICLEID],0)),"Relevant","Not relevant")

Andreas.