Populate cell from other sheet if conditions are met

Hi, I’m not sure if that has been covered or possible.

I’m trying to collate data and I have test results for devices from the past 6 years that have been tested every 6 months. They have a deviceID and come back with the date of the test and whether they have passed or failed.

I’m trying to collate the data so that for each device there is a column with the every test date and the associated pass/fail.

So Dev ID | Test Date Time Jul ‘20 | Result Jul ‘20 | …cont.

I’ve tried pivot tables, Get data, XLOOKUP, and I’m having any success ..

Is there a way to say - If there is a cell in sheet 1 that matches (A2 in sheet 2), then the corresponding cell in column C in sheet 1 is entered into ‘selected cell’ ???