Forum Discussion
Choppa1
Jan 08, 2025Copper Contributor
Lookup & Reference
Need some help formulating this one...
If I have a site in either the F "or" G column I need the corresponding region identified in the H column. I have the XLOOKUP in the H column but currently it's only applied top the F column. I don't know how to apply it or this kind of lookup and reference to two columns.
The corresponding regions are identified on a separate tab...
Can anyone help me out with this?
Cross-posted at https://answers.microsoft.com/en-us/msoffice/forum/all/lookup-reference/3fa39c5e-1888-4577-a1a1-134414b42262
I replied there:
=XLOOKUP(F2, 'Other Tab'!$B$2:$B$1000, 'Other Tab'!$C$2:$C$1000, XLOOKUP(G2, 'Other Tab'!$B$2:$B$1000, 'Other Tab'!$C$2:$C$1000, ""))