Forum Discussion

Choppa1's avatar
Choppa1
Copper Contributor
Jan 08, 2025

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

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...

 

Resources