Cross Referencing 2x Columns

Hi All,

I have a data sheet with has a couple of tabs, one tab ('Tank Data') Contains a date (Next Out-of-Service Inspection Due Date). I have another tab called 'A02's' This has the a cell where i want that data on the tank data tab. Depending on the data in Column A & C in the Tank Data tab matching with the data in column A & B on the other tab. I have tried xlookup but to no joy. Wondered if anyone could help.

Workbook attached. TIA

**EDIT**

I have been advised to edit this post to be clearer in my request.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thanks for your message. It's the TITLE you need to improve, please, NOT the post. Thanks.

**EDIT**

I have been advised to edit this post to be clearer in my request.

Everyone can see my message so they know that you were asked to edit not your post, but your thread title, which you have now done. Thanks.

The thread is now open for help.

Please try

=XLOOKUP(A2&B2,Tank_Data[Terminal]&Tank_Data[Tank Number],Tank_Data[Next Out-of-Service Inspection Due Date])