XLOOKUP based on conditional IDs

[Alotheal]

Hi all,

I have a table with 6 rows, it looks something like this.

Job Stage

Job Description

Job Status

Job Sequence

Job ID

Car ID

Stage 1	Fill Gas	In Work	56	Job123	3
Stage 1	Fill Gas	Complete	31	Job123	2
Stage 3	Fix Door	Not Started	35	Job234	2
Stage 2	Fix Door	Complete	12	Job234	1
Stage 5	Paint	Need Inspection	54	Job876	1

I have a database of work instructions (the table above), data above is fabricated but the essence is present. Essentially I want my table on another page to act like this.

"Populate Sequence"

<Insert Job ID>

"Populate Description"

"Populate Status"

"Populate Todays Date" (Possible?)

Each sheet will be a different "Car ID" I have to manage 3 different ones. Think serial numbers, different entities, similar but NOT same build.
So basically,
1. I'd type in the Job ID
2. Based on what excel sheet I'm on it will look for the ID and populate the rest of the data conditional to the Car ID.
ex. I am on sheet two or "Car ID 2". I lookup Job123, multiple builds have the same job but the information is different. So I want it to say if it's not car ID 2 keep looking, if it is stop.

I will continue to mess around with this. What I have currently created is an XLookup, I just don't know how to bounce the Job ID off the Car ID to return the correct row. My first thought was an IF="2", XLookup yeah yeah yeah, (THIS IS WHERE I GET LOST, instead of returning an error I want it to keep searching.)

The data I input will have an output, it is clean.

Ideas and solutions highly welcomes,
Thanks guys!

 

[jaeiow]

Xlookup has an argument If not found. Instead of If =2, you put xlookup(''$jobID$cell, jobIDcolumn, currentColumn, ifnotfounddosomething). But if you want to return multiple, you would use something like Filter