Forum Discussion
Choppa1
Jan 08, 2025Copper Contributor
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...
More or less a duplicate of https://answers.microsoft.com/en-us/msoffice/forum/all/lookup-reference/3fa39c5e-1888-4577-a1a1-134414b42262Lookup & Reference | Microsoft Community HubLookup & Reference | Microsoft Community Hub and of https://techcommunity.microsoft.com/discussions/excelgeneral/lookup--reference/4363896