I have a project planner where the job # has a format x.001 thru x.999.,
where we can have multiple tasks for the same job.

I have a 2 sheets, 1 lists all the jobs that require work and 1 sheet lists
the available facilities and which jobs are currentlly active in them.

The facility sheet has colums job# (x.xxx) and a completion date and time
amongst other columns of info.

so I may have
lab# - job# - completion
1 - 1.001 - 17:01 Mar-23
2 - 2.001 - 03:42 April-5
3 - 1.008 - 01:00 Mar-22

the jobs will be inserted into the labs as they become available and the lab
sheet will not be in job order but lab order.

I want to be able to say job1 finishes at 01:00 on mar-22 ie the max of the
date column for the integer of the job column)

vlookup wont let me do that

any ideas?