Xlookup to Find a Value in 2 Columns

[CF64]

Hello,
Is there a way to look in multiple columns for a value using xlookup?

Example:
Worksheet 1

A	B
Unique_ID	Return_Value (xlookup formulat goes in this column)
abc123	orange
def123	apple

Worksheet 2

A	B	C
Unique_ID_1	Unique_ID_2	Value
abc123	efg345	orange
cde123	def123	apple
bc3123	lmn999	grapes

In worksheet 1, I would like to find the unique ID in column A in worksheet 2 columns A or B and return the value in worksheet 2 column C
So,
lookup 'abc123' in columns A and B of worksheet 2 and return Orange
lookup 'def123' in columns A and B of worksheet 2 and return apple

Thank you for your consideration

 

[Fluff]

How about

=XLOOKUP(A2,Sheet2!$A$2:$A$100,Sheet2!$C$2:$C$100,XLOOKUP(A2,Sheet2!$B$2:$B$100,Sheet2!$C$2:$C$100,""))

 

[CF64]

Awesome, thank you! and thank you for the fast reply!

 

[Fluff]

You're welcome & thanks for the feedback.