Two column XLOOKUP thing...I think...

[Choppa1]

Looking for a formula...

If either F2 "or" G2 contain a site...(as displayed) I need H2 to display the corresponding Region. As you can see I'm currently using XLOOKUP but I only know how to apply it to the one column. As you can see in the 9th row I'm getting the #N/A error...

The corresponding regions are on a separate tab...

Can anyone help me out on this one..?

 

[Fluff]

Hi & welcome to MrExcel.
You can put another xlookup for G2 in the "if not found" argument of your existing formula.

 

[rcocrane99]

Let me know if something like this works
Formula applies to the highlighted cell.

=IF(AND(C4="",D4=""),"",IF(C4="",XLOOKUP(D4,$C$10:$C$13,$D$10:$D$13),XLOOKUP(C4,$C$10:$C$13,$D$10:$D$13)))

In your case I would do something like:
=if(AND(F2="",G2=""),"",if(F2="",xlookup(G2,Regions!B:B,Regions!C:C),xlookup(F2,Regions!B:B,Regions!C:C)))

please note that I have prioritized the site over the cam sites so you can see alpha and bravo are present but it chooses region 1 over 2 but in the second row its the reverse

 

[Alex Blakenburg]

In your case using the not found position as suggested by Fluff, it would look something like this:

=XLOOKUP(F2,Regions!B:B,Regions!C:C,XLOOKUP(G2,Regions!B:B,Regions!C:C))